How to change address, city, state zip code into separate columns

M

mastertype

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.
 
P

Per Jessen

Hi

Look at the TextToColumns function on the Data menu.

Select the entire column and follow the wizard.

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to Separate City, State, Zip 6
Transposing an Address List 2
Move rows into columns 3
Text to column using multiple spaces?? CITY STATE ZIP 2
City State Zip 3
parseing out City, State ?? 3
Re-organizing list information into filterable table 1
Database sorting 1

Top