View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default Save a spreadsheet in.csv format ?

Don't look at the .CSV file using excel.

Look at the .CSV file using Notepad.

If it still looks wrong, maybe you could use a macro that wrote the data the way
you want.

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

======
Earl's may be sufficient right out of the box. He supports lots of options.

pparker wrote:

When I use the Save As option under file, and save as a tab or comma
delimited format, the spreadsheet still looks the same. I need it to have the
commas and the quotation marks around the names and email address so I can
upload my list to my email blaster.

I have put the names and email address of my clients in an excel spreadsheet
and now I can't do anything with them, unless I can copy them someway with a
text file converter.


--

Dave Peterson