All functions / Text

LEN

The number of characters in a text value.

Syntax

=LEN(text)

Arguments

• text: The text (or a cell containing it).

Example

=LEN("Excel") → 5

Practise it

• LEFT, RIGHT, MID and LEN
• Splitting text at a character
• Text surgery with nested formulas