The LEN function

Counts the characters in text.

In German Excel: LÄNGE

How to write it

=LEN(text)

text: The text or cell.

💡 Spaces count too, which is useful to spot messy data.

Try it

How many characters long is the code in C3?

D3

A

B

C

D

1

Full name

City

Code

Length

2

maya lopez

berlin

TS-1042-BLU

3

LEO KING

paris

HD-0077-RED

4

sam o’neil

Rome

MG-3150-GRN

LEN counts characters, dashes too.