View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

XL's default csv format will put quotes around data that includes quotes.


If you still want every field to have quotes, take a look at

http://www.mcgimpsey.com/excel/textf...#csvwithquotes



In article ,
"Marc" wrote:

I need to export an excel spreadsheet to CSV but I need every field to have
quotes around it because some of the fields have a comma as part of their
value, is their anyway to do this.