Comma or Semicolon in an Excel formula

Why does Excel expect commas or semicolons to separate the parameters in a formula? The answer can be found in this article.

Comma or semicolon ?

If you read this article, it's because one day you noticed that the separator between the parameters in any function is the comma sign or the semicolon.

Sometimes the separator is a comma

Comma separator

Sometimes the separator is a semicolon

Semicolon separator
Semicolon separator

Changing this is not an Excel option. It's a Windows parameter.

Windows settings

To switch between comma or semicolon as separator, follow the next steps

1. Open your Windows settings

2. Select the Time & Language menu

Windows Setting

3. Then select Region & language > Additional date, time & regional settings

4. Click on Region > Change location

Shortcuts

You can open the same dialog box with the command line intl.cpl in the search bar 😉👍

Change your setting

Now, you just have to select one country to change your setting. The parameter that can be changed is the List separator option

US settings

France, Spanish settings

You don't have to Restart Excel to apply the settings

Related posts


Permanent link to this article: https://www.excel-exercise.com/comma-or-semicolon-in-excel-formula/


Leave a Reply

Your email address will not be published.