Skip to content

LEN

TextExcel 2007

Number of characters in a string.

Syntax

LEN(text)

Examples

=LEN("Namaste")

→ 7

=LEN(A2) - LEN(SUBSTITUTE(A2, " ", ""))

→ 3 — Counts spaces (≈ word gaps).

Related functions

SUBSTITUTETRIM

More Text functions

ARRAYTOTEXTASCBAHTTEXTCHARCLEANCODECONCATCONCATENATEDBCSDOLLAREXACTFIND

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.