Functions
LEN
Number of characters in text
Try it
When to use it
What does LEN count?
LEN returns the number of characters in a piece of text, including spaces and punctuation. Numbers are counted by their displayed digits.
How can I check that an ID is the right length?
Wrap LEN in a comparison, for example LEN(id) = 8, to flag values that are too short or too long for a fixed-format code.
Use cases
Validate a five-character postal code length
Measure the length of a serial number
Used in
Syntax
LEN(text)Examples
=LEN("lorem ipsum") // => 11
=LEN("") // => 0
=LEN("熊本") // => 2