ExcelBanter - How do I force quote marks when exporting to a csv?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I force quote marks when exporting to a csv? (https://www.excelbanter.com/excel-discussion-misc-queries/156150-how-do-i-force-quote-marks-when-exporting-csv.html)

brussteck

How do I force quote marks when exporting to a csv?

When exporting to a csv file, Excel only places the double quote marks around
certain fields. I need it to place quotes around all fields. Is there an
option to specify that?

JE McGimpsey

How do I force quote marks when exporting to a csv?

See

http://www.mcgimpsey.com/excel/textfiles.html

In article ,
brussteck wrote:

When exporting to a csv file, Excel only places the double quote marks around
certain fields. I need it to place quotes around all fields. Is there an
option to specify that?

All times are GMT +1. The time now is 06:40 AM.