tkaplan
05-20-2011, 08:29 AM
I have a spreadsheet that in column a there are a bunch of items that I need split out into columns. There are at least 2 spaces separating the items so I need at each point where there are 2 or more spaces to break it out into a separate column.
for example, in column A row 1 it says:
0211584 GREEN MAX 4/2/11 $405.00 8588 KAPLAN T
So I need B1 to have 0511584, c1=GREEN MAX (only one space btw. the words), d1=4/2/11, e1=$405.00, f1=8588, g1= KAPLAN T
I know I can have column B with just a simple left(a1,search(" ",a1)). what about the rest of the columns?
TIA
for example, in column A row 1 it says:
0211584 GREEN MAX 4/2/11 $405.00 8588 KAPLAN T
So I need B1 to have 0511584, c1=GREEN MAX (only one space btw. the words), d1=4/2/11, e1=$405.00, f1=8588, g1= KAPLAN T
I know I can have column B with just a simple left(a1,search(" ",a1)). what about the rest of the columns?
TIA