When i save a worksheet as CSV format in Xcel 2016 the variables are separated by semi-Colons instead of Commas.This causes severe problems
When i save a worksheet as CSV format in Xcel 2016 the variables are separated by semi-colons and not comms.
This causes severe problems when importing CSV files in other applications. Cel 2011 correctly exports CSV files with commas separating the variables.
Alexander Henket commented
In the Dutch translation the option is literally called "CSV UTF-8 (separated by commas) (.csv)" so the fact that I found semicolons instead was a surprise. But, in all fairness: Excel 2011 also exports using semicolons on my system.