Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I output csv files from Excel with quotes round text fields
Example:
A1 = 123, B1 = XYZ, C1 = 0, D1 = THISISTEXT Saving as csv will generate 123,XYZ,0,THISISTEXT I want to output 123,"XYZ",0,"THISISTEXT" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I output csv files from Excel with quotes round text fields
Excel likes to do what it wants. If it thinks you don't need the qualifier, it
won't put them in. Maybe you could write your own exporting program that would behave exactly the way you want: Here are three sites that you could steal some code from: Chip Pearson's: http://www.cpearson.com/excel/imptext.htm J.E. McGimpsey's: http://www.mcgimpsey.com/excel/textfiles.html (or maybe you could build your own formula that concatenates the cells using a giant formula and copy|paste into Notepad.) DickG wrote: Example: A1 = 123, B1 = XYZ, C1 = 0, D1 = THISISTEXT Saving as csv will generate 123,XYZ,0,THISISTEXT I want to output 123,"XYZ",0,"THISISTEXT" -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I output csv files from Excel with quotes round text fields
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm DickG wrote: Example: A1 = 123, B1 = XYZ, C1 = 0, D1 = THISISTEXT Saving as csv will generate 123,XYZ,0,THISISTEXT I want to output 123,"XYZ",0,"THISISTEXT" -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel ignores "Text qualifiers" in Unicode files | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
setting text qualifier in Excel | Excel Discussion (Misc queries) | |||
Stop Excel from converting text labels in CSV files to Values | Excel Discussion (Misc queries) |