View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PM PM is offline
external usenet poster
 
Posts: 7
Default Quotes and CSV files

When saving a CSV file and a cell contains quotes, Excel adds more quotes -
I guess this is the CSV standard.

For example, if cells A1:A3 are

"test"
""
Test

then Excel will save as

""test"","""",Test


I want to save like this

"test","",Test


Anyone?