Summary of the solutions to this problem:
Excel insists that a CSV file is "comma separated" even though you tell it otherwise.
In order to overcome this bug, change the file extension to .txt or open the file using data > from text.
Microsoft, please fix this bug. Thanks.
I am using the text to columns feature but there seems to be a bug.
I export a CSV file from another application with the delimiter set to SEMICOLON and enclose strings with "
Open the file in Excel, and use the text to columns feature.
I set the delimiter to SEMICOLON only.
When I click text to columns I get the data in columns but whatever data in a cell that has comma disappears.
"Stone company, Copenhagen";"Denmark"
I have double checked many times that the comma delimiter checkbox is not set.
Tried to set and reset the comma delimiter checkbox before converting.
Looked in the settings to see if there is some setting I can change but didn't find it.
I am now removing the commas in a text editor before importing in order to avoid the problem but this is annoying.
Any idea how to fix this other than wait for the next version?