How can I convert an ordinary text file to a .csv file, and import it to Excel?
- by Xavierjazz
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.