How to make Excel strip ALL quotes from CSV text fields
- by Klay
When importing a CSV file into Excel, it only strips the double-quotes from the FIRST field on the line, but leaves them on all other fields. How can I force Excel to strip the quotes from ALL strings?
For instance, I have a CSV file:
"text1", "text2", "numeric1", "numeric 2"
"abc", "def", 123, 456
"abc", "def", 123, 456
"abc", "def", 123,…