| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change address, city, state zip code into separate columns
I downloaded a list of company addresses that have the street address, city,
state, zip code and country in one column. I need to change this to one column for each item. How can I do this? There are over 5000 lines in the file that I downloaded. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to Separate City, State, Zip | Excel Discussion (Misc queries) | |||
| Seperate Name, Street Address & City, State Zip | Excel Worksheet Functions | |||
| separate an address street/city,state,zip within a cell? | Excel Worksheet Functions | |||
| I wish to separate city, state, and zip into 3 separate columns | Excel Worksheet Functions | |||
| zip code to city, state function | Excel Worksheet Functions | |||
Threaded Mode
