View Single Post
  #2   Report Post  
Troy
 
Posts: n/a
Default

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?