LEN

Definition: LEN is a function that returns the number of characters in a text string.

Syntax: =LEN(text)

Situation: This formula is appropriate when you need to find the number of characters in a text string.

Example: If you have a text string “apple”, the number of characters can be found using the formula =LEN(“apple”), which returns 5.