How do I convert an excel file into a comma separated values file


G

Guest

I have an excel file composed of people's names and addresses, that is, one
cell has the first and last name, the following cell has the whole address
and the third cell has the phone no. All these are in column A. I want to
convert them into separate fields/columns such as - first name, middle name,
last name, street address, city, state, zip code and phone.
I am using MS Office Professional 2003 - Excel 2003 SP2

Thanks
 
Ad

Advertisements

G

Guest

Save As .csv file.

But is that what you're asking? or are you asking how to separate all that
information into separate columns? If its the latter, go to Data-->Text to
columns and follow the instructions.
 
G

Guest

I want all the information separated into columns. I tried what you
suggested to go to Data but cities that are two words like San Francisco are
in two columns; zip codes are in thousands sepated by commas with two decimal
points like 90,230.00; same wit h street addresses.

Need more help. Thanks
 
Ad

Advertisements

G

Guest

When you go into Data-->Text to columns, select 'fixed width' and insert
column separators where you need to.

You may still need to clean up the data after the wizard closes.
 

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

Top