Formulas and Functions
Modifying this control will update this page automatically

LEN

The LEN function returns the number of graphemes in a string value.

LEN(source-string)

source-string: Any value.

Notes

  • The count includes all spaces, numbers and special characters.

    Note: A character with diacritics is counted as a single grapheme.

Examples

=LEN("12345") returns 5.

=LEN(" abc def ") returns 9, the sum of the six letters plus the leading, trailing and separating spaces.

Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.