I have a CSV file that with quoted string that contains comma
. When I open it in excel it still uses the comma inside the strings and parse it in different columns. Can someone help?
T7, 7, "331-8463 C - Ind. HT collar, laser HT insert, crown TR", 85, 0.37, N, 0.00, N
T7, 8, "331-8463 C - Ind. HT collar, laser HT insert, crown TR", 90, 0.33, N, 0.00, N
Simply create a CSV file with the above two lines and open it in Excel File.
Here is the result I get.
Best Answer
Remove the extraneous spaces and it'll work correctly: