MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Converting rows of data (e-mail addresses) into a comma delimited file

Posted by Brendon Sinclair on November 09, 2001 2:37 PM


This sounds easy (!) but I just can't figure out how to convert rows of data (e-mail address in each row) into a comma delimited file.

Any help would be greatly appreciated.



Posted by Lewis on November 09, 2001 3:22 PM

Isn't it just File/save as then select comma separated *.CSV


Posted by Jack on November 09, 2001 3:29 PM

Save your Excel xls file into *.csv or txt which will do the job, file | save as | name the new work | and chnge the format tossave in, click the arrow down - scroll to CSV,

Posted by Mark W. on November 10, 2001 1:56 PM

Okay, here's my guess at what you want. You have
a column of email addresses (one on each row) and
you want to convert it to a horizontal comma
delimited list. Here's how that can be accomplished:

1. Copy your list to column a of a new
(previously unused) worksheet.

2. Save that worksheet with a .txt extension
(e.g., Book1.txt) and close your workbook.

3. Open Book1.txt using a text editor (I'll
assume that you're using Word).

4. Replace all occurances of ^p with a comma.

5. Delete the trailing comma from the text.