Saving as a csv file with text qualifiers

[Rajendra Pai]

I have the following three values in 3 cells

a1 b1 c1
adam john lilly

I want to export this into a csv file that should look like this:
"adam","john","lilly"

How do I do it?
Thanks in advance for the help

 

[JE McGimpsey]

One way:

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

 

[Earl Kiosterud]

Rajendra,

You can use the Text Write Program at www.smokeylake.com/excel. It's an
Excel workbook that will write any sheet of any open workbook as a text
file. There's an option to put text qualifiers in all fields.