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)

 

 

 

xlPrecision Home Page
PrecisionCalc Home Page