How to save Excel doc to CSV with quotations around each item. E..

[Guest]

I need to save Excel 2003 docs to a CSV with quotations around each item.
E.g., "Doe", "John", "123121234"

 

[JE McGimpsey]

Take a look here:

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

 

[RWN]

Don't think you can without using VBA (but, believe me, I've been wrong before!).
It will, however, insert quotes where required i.e. if a cell has a field delimiter
(comma) in it.
ex Doe,John (in one cell) will be saved as "Doe,John"
vs. Doe John (in two cells) will be saved as Doe , John

 

[Earl Kiosterud]

The Text Write Program, and Excel workbook with a macro that writes any
sheet to a text file with lots of options, will do that.
www.smokeylake.com/excel.