saving as csv but quoted fields

[Corrlens]

How can I make excel add the quotes within each field delimited by commas ?
I have data that has commas within the fields and it's messing up when I
import on other programs.


("one","two","three") and not (one,two,three)

Thanks

 

[Dave Peterson]

Maybe you could write your own macro to do exactly what you want:

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

(You may be happy with Earl's version--right out of the box!)