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