Here's an ie: of my data:
HW0000036 TFE Thread Tape (48 FT)
HW0000150 Clamp, Hose, Nylon, 1/4\'94
KIT000093 CD, UV Filter 214 NM
What's the easiest way to extract the P/n and Description and place it in separate columns.
A1 to B1 and C1
I used =LEFT(A1,8) for the P/N.
Of course this is only good if the P/N's are the same length.
How do I handle the DESC?
Or is there an easier way?
HW0000036 TFE Thread Tape (48 FT)
HW0000150 Clamp, Hose, Nylon, 1/4\'94
KIT000093 CD, UV Filter 214 NM
What's the easiest way to extract the P/n and Description and place it in separate columns.
A1 to B1 and C1
I used =LEFT(A1,8) for the P/N.
Of course this is only good if the P/N's are the same length.
How do I handle the DESC?
Or is there an easier way?