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

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.

"Conquerer" wrote:

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

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

"Dave F" wrote:

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.

"Conquerer" wrote:

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

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.

"Conquerer" wrote:

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

"Dave F" wrote:

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.

"Conquerer" wrote:

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