I've a CSV file opened with Excel. This file use comma separators (
,) but the default separator for Excel (with European configuration) is a semicolon (
Note: I know in America they use a comma separator but in Europe we use a semicolon separator. This we do because a comma is used for a decimal operator.
The Excel developers knows that this is an issue for European CSV files (with
;) and use also a semicolon because Excel and my computer is European configurated.
The file I'll open is now an American CSV file that uses commas as separator.
My question is how can I dynamic change the separators in Excel 2016 without changing the configuration of my computer every time?
If I will save the file and I've three options:
- CSV (MS-DOS) (
- CSV (Macintosh) (
- CSV (
seperated by list separator stabbingcomma delimited) (
See image below
1 In Dutch version and image: gescheiden door lijstscheidingsteken.
No idea what this means.
I've tried this three options but none will separate the CSV file correct.
The answer from @Gary's Student is good but the commas are changed again to a semicolon. This is not what I want.