What is the use of LEN Function in Excel?

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