LEN
Returns the number of characters in a text string.
TextBeginner EssentialsMost UsedText Processing
What it does
Returns the number of characters in a text string.
Syntax
LEN(text)
Arguments
text(text) — Text to count characters in.
Examples
Count characters
Count characters in A2.
FORMULA
=LEN(A2)
RESULT
8
SAMPLE DATA
| A | |
|---|---|
| 1 | Text |
| 2 | Ana Silva |
| 3 | Tom |