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? |
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? |
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 |
All times are GMT +1. The time now is 10:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com