ƒxPlainFormulaThink in English. Formula in Excel.

FUNCTION CATALOGUE / TEXT

LEN Excel function

Counts characters in text.

Correct sentence to use

Count the characters in [text].

Modify this query in PlainFormula →

Example formula

=LEN(A2)

Returns the number of characters.

Syntax

LEN(text)

Argument signature: text

Availability note

Commonly available in current Excel; verify platform and locale-specific behaviour.

Check Microsoft's Excel function documentation ↗

← Browse all functions