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

Take a look here:

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


In article <OJ4b$(E-Mail Removed)>,
Rich Pasco <(E-Mail Removed)> wrote:

> 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

Rich,

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

"Rich Pasco" <(E-Mail Removed)> wrote in message
news:OJ4b$(E-Mail Removed)...
>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