CSV format - puting quotes around all strings

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 <[email protected]>,
Rich Pasco <[email protected]> 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" <[email protected]> wrote in message
news:[email protected]...
>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

Thank you, that looks like it will do what I want.

- Rich

JE McGimpsey wrote:

> Take a look here:
>
> http://www.mcgimpsey.com/excel/textf...#csvwithquotes
>
>
> In article <[email protected]>,
> Rich Pasco <[email protected]> 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

Thank you. That looks like a very useful tool. I'll try it.

- Rich

Earl Kiosterud wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
>>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
>
>