View Full Version : Solved: formula to split a cell

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?


05-20-2011, 08:35 AM
1) Select the entire Column with actual text
2) Click on Data Tab and select Text to Columns
3) Make sure that Fixed Width is selected in the pop of window and Click Next
4) In the next window , you will see data preview with vertical lines and how the data would be split, you can move the vertical line to adjust to your needs.
and click ok

05-20-2011, 08:39 AM