The Excel LEN function returns the length of a given text string as the number of characters. LEN will also count characters in numbers, but number formatting is not included.
- Purpose: Get the length of text.
- Return value: Number of characters
Syntax
=LEN (text)
Arguments
- text - The text for which to calculate length.
Example:
LEN returns the count of characters in a text string:
=LEN("apple") // returns 5
Space characters are included in the count:
=LEN("apple ") // returns 6