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

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

Take a look he

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



In article ,
"tnbanjoman" wrote:

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

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

--
Regards;
Rob
------------------------------------------------------------------------
"tnbanjoman" wrote in message
...
I need to save Excel 2003 docs to a CSV with quotations around each item.
E.g., "Doe", "John", "123121234"

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.


--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

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