Feb 01 2024 07:54 PM
Hi,
I'm having trouble converting my Excel file to CSV where each box is separated with semicolons instead of commas. I'm not sure if it's just a MacBook thing. but I would appreciate some help.
Feb 02 2024 12:31 AM
Which separator will be used depends on your regional settings. Most probably semicolon is your default one. The means formula in your environment looks like =IF(true;1;2), not =IF(true,1,2).
Ways to change are here How to change Excel CSV delimiter to comma or semicolon (ablebits.com) . Above is for Windows but for Mac it shall be similar.