Excel functions

The LEN function

Returns the number of characters in a text, spaces included.

Syntax

LEN(text)

text: The text or cell to measure.

Examples

C1=LEN(A2)

	A	B	C
1	City		10
2	Copenhagen

C1=LEN(" hi ")

	A	B	C
1	City		6
2	Copenhagen

Practice LEN

Read the guide

Related functions