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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change address, city, state zip code into separate columns
Hi
Look at the TextToColumns function on the Data menu. Select the entire column and follow the wizard. Regards, Per "mastertype" skrev i meddelelsen ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change address, city, state zip code into separate columns
Hi,
Use text to columns, Delimited, choose one option "mastertype" wrote: 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. |
Reply |
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 |