How to export to "data-1","data-2","data-3" format ?

[tmb]

I need to create a delimited file where each field is delimited by a comma
and each field is contined in double quotes... like...

"data-1","data-2","data-3","data-4", etc

Can I do this from Excel?

If so how?

(I see comma delimited csv but that doesn't put the quote marks in"

thanks for any help.

 

[Dave Peterson]

J.E. McGimpsey has done the work for you!

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

Look for "CSV with quotation marks around each field"

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


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

has options built into that do what you want (right out of the box).

 

[Earl Kiosterud]

tmb,

Normally, the quotation marks aren't needed around fields, unless they
contain quotation marks in the data, or there's a field delimiter (comma) in
the data. It's sufficient to have field delimiters between the fields. But
if you're sure you need them, the Text Write Program Dave mentioned has an
option to put them around all the fields.