| 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 , |
| 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) | |||
Threaded Mode
