
Variant of LENGTH.
Returns the number of characters in a text string.
Syntax
LEN(X)
where:
- x: Text-formatted line item to evaluate
Note: If you use LEN(x) in the Anaplan formula bar it is automatically updated to LENGTH(x).
Format
Input Format | Output Format |
---|---|
x: Text |
Number |
Arguments
The function uses the following arguments:
- x: Text: Text-formatted line item, text constant, list-formatted line item, or general expression
Constraints
The function has the following constraints:
- Source must be text-formatted.
- Result must be number-formatted.
- White spaces are counted for text string length.
- If source is blank, the function returns 0.
Excel equivalent
Example
The number-formatted Length of text-formatted cell result line item returns the length of text entered into the text-formatted y line source line item:
LEN(y)
updated to
LENGTH(y)
The number-formatted Length of list-formatted cell result line item returns the length of text selected in the list-formatted x line source line item:
LEN(NAME(x))
updated to
LENGTH(NAME(x))