Creating a csv

  • Thread starter Thread starter Tony Williams
  • Start date Start date
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
 
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.
 
Thanks Dave worked like a dream I thought I was going to have to do that
manually with 900 email addresses :-)
Thanks again
Tony
 
Back
Top