PrecisionCalc
xl
Precision
Get Your Numbers Right
xlpLISTSEP
Identifies the list separator character to use between function arguments.
The list separator character can vary by language, and can be customized in a Windows control panel. For English speakers and many others where the decimal separator character is a period, the list separator character is normally the comma. For many other languages, where the decimal separator character is a comma, the list separator character is normally the semicolon. But Windows allows setting it to any character. This function is for troubleshooting purposes, to check whether you're using the correct list separator character between function arguments on your computer.
Syntax
xlpLISTSEP(spellout)
spellout | Optional. Set to True to spell out the list separator character name if it is a comma or semicolon. False by default. |
Example
Formula | Description | Result |
=xlpLISTSEP() | Get the list separator character. | ,
(in the
USA) ; (in France) |
=xlpLISTSEP(TRUE) | Get the list separator character, and spell it out if it's a comma or semi-colon. | , (comma)
(in the
USA) ; (semicolon) (in France) |