Creating a csv

[Tony Williams]

I have a spreadsheet with a list of email addresses in the first column. I
want to create a CSV file. If I choose Save as---> csv and then open the csv
file in Notepad the list is saved as a list with carriage returns after each
email address and no commas. So how do i turn the list into a continuous list
with no breaks and a comma seperating each one? I'm using Excel 2007
Thanks
Tony

 

[Dave Peterson]

Open the file in MSWord and do an edit|replace (or the MSWord 2007 equivalent)
to change the paragraph mark (under the More button and then under the Special
button) to a comma.

 

[Dave Peterson]

ps. Remember to save the file as a text file, too.

 

[Tony Williams]

Thanks Dave I'll try that and let you know how I get on.
Tony

 

[Tony Williams]

Thanks Dave worked like a dream I thought I was going to have to do that
manually with 900 email addresses
Thanks again
Tony