| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
export excel file as csv with text delimiter of "
Does anyone know how to export data from an .xls file to a csv, and encode
all text fields with double quotes ""? I can use "save as" to get a csv file, but then the text does not have double quotes. any ideas? |
|
#2
|
|||
|
|||
|
If the text fields are all within a certain column (or row or block), you
could use the formula """"&A1&"""" (for example, if the text were in cell a1), then copy & paste value over the original data. "John" wrote: Does anyone know how to export data from an .xls file to a csv, and encode all text fields with double quotes ""? I can use "save as" to get a csv file, but then the text does not have double quotes. any ideas? |
|
#3
|
|||
|
|||
|
Earl Kiosterud's Text Write program:
www.smokeylake.com/excel (or directly: http://www.smokeylake.com/excel/text_write_program.htm) Has a lot of options in it. John wrote: Does anyone know how to export data from an .xls file to a csv, and encode all text fields with double quotes ""? I can use "save as" to get a csv file, but then the text does not have double quotes. any ideas? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a Word text file into Excel in a way that each char. | Excel Discussion (Misc queries) | |||
| Opening an Excel file | Excel Discussion (Misc queries) | |||
| How do I export an excel file as fixed length records | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| How do I export a csv file from Excel with fields enclosed in dou. | Excel Discussion (Misc queries) | |||
Linear Mode
