text find

[choice]

i have:
"A1" San Diego, CA 94588
"A2" Seattle, WA 96811
"A3" Honolulu, HI 96822
etc...

I need for the City to be in one cell, State in the other, and ZIP in another
"A1" San Diego "B1" CA "C1" 94588
i tried doing a find replace, based on the comma, but i cant seem to get it
right.

please help

Thank you

 

[sebastienm]

Hi,
- Select the column of data
- go to to menu Data > Text To Column.
- Step 1 of 3, choose Delimited
- Step 2 of 3, choose Comma
- Step 3 of 3: select both data columns in the dialog and choose Text as
data type
- click Finish
Now you have city in a column and State&Zip in the following column
- Select the State&Zip column and redo the above process, but this time, in
step 2 of 3, choose Space as a delimiter.
(make sure you choose Text data type.)

Regards,
Sebastien

 

[Tom Ogilvy]

Select column A,

Do Data=>Text to columns

Select delimited

in the second dialog, select comma only as the delimiter

then finish.

Now select column B and repeat, but select space as the delimiter to
separate the state and zip.

This will give you a column of just spaces in Column B, so you can then
delete column B.

try this on a copy of your data.