double quotes when saving as CSV or tab-delimited

[alanwolf1972]

Excel adds double quotes when an entry contains special characters
when saving as CSV or tab delimited, microsoft publishes a macro to
fix this, but I am having trouble with it, any other solutions?
Support.microsoft.com/kb/104997

thanks

 

[Dave Peterson]

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

(or maybe you could build your own formula and copy|paste into Notepad.)