Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
text find
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
text find
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 "choice" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
text find
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. -- Regards, Tom Ogilvy "choice" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find text in free-format text field | Excel Discussion (Misc queries) | |||
Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
backwards find function to find character in a string of text | Excel Programming |