splitting data from 1 column into multilple?
To answer your question pre se, with a formula solution.....you cannot do it
with "a" formula.....it will take 5 formulas, ie:
with your data in columns A and B, put the following formulas in columns C,
D, E, F, and G, copying down as appropriate.
In C1 put........ =MID(A1,1,FIND(" ",A1,1))
In D1 put.........=MID(A1,FIND(" ",A1,1),99)
In E1 put.........=MID(B1,1,FIND(" ",B1,1))
In F1 put.........=MID(B1,FIND(" ",B1,FIND(" ",B1,1)),LEN(B1)-6-5)
In G1 put.........=RIGHT(B1,5)
And, like Harlan says, the data must conform to a strict format, including 5
diget Zip, and no extra spaces
Vaya con Dios,
Chuck, CABGx3
"Dan B" wrote in message
...
Hi,
I have 2 columns with data I need to split up. One column contains first
and last names. I need that into 2 columns, first in one, last in
another.
The other column of data has City ST Zip. There are no commas or periods.
I need that split into 3 columns.
I need help with a formula to do that.
Thank you!!!
|