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

[tnbanjoman]

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/textf...#csvwithquotes



In article <[email protected]>,
"tnbanjoman" <[email protected]> wrote:

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

[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

--
Regards;
Rob
------------------------------------------------------------------------
"tnbanjoman" <[email protected]> wrote in message
news:[email protected]...
> I need to save Excel 2003 docs to a CSV with quotations around each item.
> E.g., "Doe", "John", "123121234"
>
>

[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.


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

"tnbanjoman" <[email protected]> wrote in message
news:[email protected]...
>I need to save Excel 2003 docs to a CSV with quotations around each item.
> E.g., "Doe", "John", "123121234"
>
>