| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comma Delimited, saving of records - CSV File
I did a Google with the terms: Excel CSV quotes
I looked at the first dozen or so but only the first seems useful to you http://www.mvps.org/access/modules/mdl0046.htm best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "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 | |||
| Saving a tab delimited txt file | New Users to Excel | |||
| Excel file not saving properly | Excel Discussion (Misc queries) | |||
| How do I password protect a comma delimited file please | Excel Discussion (Misc queries) | |||
| Excel should let me sort the file directory when saving a file | Excel Discussion (Misc queries) | |||
| how to save a file as ASCII: expanded comma delimited text (.exp). | Excel Discussion (Misc queries) | |||
Hybrid Mode
