| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I split addresses(city, state,zip)?
I am trying to print labels but I have a spreadsheet with about 1200
addresses that are not separated. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I split addresses(city, state,zip)?
Makes sure all as many columns as you want to split this into are empty to
the right select the column, then do datatext to columns and select commas as delimiter. -- Regards, Peo Sjoblom "newbie101" wrote in message ... I am trying to print labels but I have a spreadsheet with about 1200 addresses that are not separated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| parseing out City, State ?? | Excel Discussion (Misc queries) | |||
| City State Zip | Excel Discussion (Misc queries) | |||
| City State Zip | Excel Worksheet Functions | |||
| city, state, zip in same cell | Excel Discussion (Misc queries) | |||
| Splitting City State Zip | Excel Worksheet Functions | |||
![newbie101[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
