How can I convert an ordinary text file to a .csv file, and import it to Excel?

Posted by Xavierjazz on Super User See other posts from Super User or by Xavierjazz
Published on 2010-06-16T15:43:21Z Indexed on 2010/06/17 15:24 UTC
Read the original article Hit count: 226

Filed under:
|
|
|

I have a group of names and addresses that I would like to import into Outlook.

At the moment I have imported them into Excel, but all names and addresses are in one long entry.

All are already separated by a comma.

How can I get Excel to select each "value" and move it to a separate cell?

Edit: I had already tried taking a text file and saving it as a .csv file. However, all contacts load into a single cell.

I am using Excel 2003.

Thanks.

© Super User or respective owner

Related posts about windows-xp

Related posts about excel