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