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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks