View Single Post
  #3   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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