1. Calculation functions
  2. All Functions
  3. Miscellaneous Functions
  4. LEN

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.

Back to Top

Excel equivalent

Back to Top

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))

Back to Top

Similar functions