Easy Ways to Change List Separator on Function in Excel

17 October 2022

Home » Blogs » Software » Ms Excel » Easy Ways to Change List Separator on Function in Excel

You can change the in using semicolons (;) or a comma (,) through the Region .

Formulas in Microsoft are expressions that manipulate values in a cell or range of cells. Like the formula =A1+A2+A3+A4, which counts the number of values in cells A1 through A4.

While a Function is a predetermined formula. For example, the =SUM(A1:A4) function, this function will sum the values in the range of cells A1 through A4.

To function correctly, a function must be written in a certain way, which is called syntax. The basic syntax for a function is an equal sign (=), a function name (SUM, for example), and one or more arguments. The argument contains the information that you want to calculate. The function in the example below will add the value of the cell range A1:A4.

TOP TUTORIALS:  How to Unblock Downloads from the Internet in Chrome

Functions with Multiple Arguments

Arguments must be wrapped in parentheses and can refer to specific cells and ranges of cells. Depending on the syntax required for the function, you can provide one parameter or more arguments.

excel list separator

Multiple arguments must be separated by a ““.  For example, a SUM function with three arguments “=SUM(A1:A6,C1:C4,E1:E2)” as in the image above.

List Separator on Functions in Excel

By default, uses the “” that has been specified in the Region in the .

TOP TUTORIALS:  GNS3 Version - Network Software Emulator

The US-English version of Excel uses a comma (,) for the list separator by default, while other international versions may use semicolons (;).

If you try to use a “List Separator” that does not match the Region , you will get an error message like this:

excel wrong list separator

Change Excel List Separator via Regional Setting

To change the List Separator in Excel, you can do this through the .

  1. Open the ““. You can open it through the Start button and in the search box type “control panel”.
TOP TUTORIALS:  TamoSoft Throughput Test - Measuring Wireless or Wired LAN Bandwidth
open control panel
  1. Then on “Clock and Region“, click the link under it “Change date, time, or number formats“.
control panel change date time format
  1. Next, will open the window “Region“. Click the “Additional settings” button.
region additional settings
  1. Then, in the “Customize Format” dialog box, select the “Numbers” tab. In the “List separator” field, type a semicolon (;) or comma (,) as you wish. Click OK button to save changes.
customize format list separator

Related Articles


Submit a Comment