LEN
Counts the characters in text.
How it’s written
LEN(text)Example
| A | |
|---|---|
| 1 | Name |
| 2 | Amara |
=LEN(A2)Result: 5
Amara has 5 characters.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
A surprising count often means there are hidden spaces.
Practice it properly
Splitting at a marker gives you real tasks, with your formulas tested on data you haven’t seen.