Saving as a csv file with text qualifiers
 

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

One way:

http://www.mcgimpsey.com/excel/textf...#csvwithquotes


In article ,
(Rajendra Pai) wrote:

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

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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Rajendra Pai" wrote in message
om...
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