| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) | |||
| Convert text file to MS_Excel | Excel Discussion (Misc queries) | |||
| Getting a file and Saving a File | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Linear Mode
