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

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

 

[Per Jessen]

Hi

Look at the TextToColumns function on the Data menu.

Select the entire column and follow the wizard.

Regards,
Per

 

[Eduardo]

Hi,
Use text to columns, Delimited, choose one option