View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default Triple Quotes when saving to *.csv

See

http://www.mcgimpsey.com/excel/textfiles.html

for one way.

In article ,
"D" wrote:

When saving the file as *.csv, some text (brought up in notebook) has no
quotes around it (i.e. text) and text with quotes around it has triple quotes
around it (i.e. """text"""). Any help on how to save an excel file as a *.csv
and have all text have double quotes around it (i.e. "text"), when read in
notebook?

Thank you