text find

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
Back
Top