CSV format - puting quotes around all strings


Rich Pasco

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question