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
) - CSV (Macintosh) (
*.csv
) - CSV (
seperated by list separator stabbingcomma delimited) (*.csv
)1
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.
Update 1
The answer from @Gary's Student is good but the commas are changed again to a semicolon. This is not what I want.