Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why Saving a file to a CSV, Excel does not put text into Quotes?
I have 300 records in excel, and when I save as a CSV file, it does not put "
" around TEXT fields. i.e. CSV File Phone # customer name address 1 5556570987,John, Smith Attorney,124 Main Street ------------- Should Be --------------- 5556570987,"John, Smith Attorney","124 Main Street" I need a Field Delimiter of " and a field seperator of , |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why Saving a file to a CSV, Excel does not put text into Quotes?
Paul,
Quotes, aka text qualifiers around these here parts, are really only specified if the data contains a field delimiter (comma), or a text qualifier character (quote mark). Otherwise they're not necessary. If you're sure you need them, use the Text Write Program at http://www.smokeylake.com/excel/text_write_program.htm. There's an option to force quotes around all fields. I think it puts them around numeric fields also. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "Paul Bytes" wrote in message ... I have 300 records in excel, and when I save as a CSV file, it does not put " " around TEXT fields. i.e. CSV File Phone # customer name address 1 5556570987,John, Smith Attorney,124 Main Street ------------- Should Be --------------- 5556570987,"John, Smith Attorney","124 Main Street" I need a Field Delimiter of " and a field seperator of , |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
Retaining formats | Excel Discussion (Misc queries) | |||
Excel should let me sort the file directory when saving a file | Excel Discussion (Misc queries) | |||
saving an excel file as text without text in quotes | Excel Discussion (Misc queries) | |||
Exporting excel to text file | Excel Discussion (Misc queries) |