Excel only places quotes around certain fields, how do I force excel to save a CSV file with quotes around every column?
|
feedback
|
|
Seems that even now, Excel has problems saving a proper CSV file. An old ExcelForum.com post lists a number of macros that do the trick. | |||
|
feedback
|
|
This page also has the solution which comes straight from the horse's mouth: http://support.microsoft.com/kb/291296/en-us If the link degrades, the topic to search for is: "Procedure to export a text file with both comma and quote delimiters in Excel" and/or "Q291296" tl;dr: use their macro | |||
|
feedback
|
