Creating a csv


T

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
 
Ad

Advertisements

D

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

Advertisements

T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top