CSV format - puting quotes around all strings

[Rich Pasco]

I notice that when I save as CSV (comma-delimited), Excel puts quotation
marks around string fields only where they are necessary (e.g. those
with embedded commas). It omits them otherwise.

I am trying to export to another application where quotes are mandatory
around every string field. Is there a way to force Excel to quote all
strings when saving a CSV?

I'm running Microsoft Offce Excel 2003 SP1

- Rich

 

[JE McGimpsey]

Take a look here:

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

 

[Earl Kiosterud]

Rich,

Try the Text Write Program at www.smokeylake.com. There's an option for
quotes around all the fields.