Text Strings Conversion

B

billyccarver

I have a text string that is in all one cell and I want to convert
portions of the string into seperate cells. Can anyone help me with
the formula for that?
Here is what the string looks like:

ALLEN, BILL,"9654 N 6620 W",,"CASEYVILLE","AZ","84487"


I need each of the name, address, city state and zip in sererate
cells.
thanks!
 
S

swatsp0p

Use Data>Text to Columns... to separate these into different cells. Set
it as Delimited and choose Comma as the delimiter.

Good Luck
 
Top