Excel + Google Sheets · LEN
Count characters in any cell
Returns the number of characters in a text, spaces included.
The formula
=LEN(A2)What each part means
A2The text to measure
Example
| A | B | |
|---|---|---|
| 1 | Ad headline | Characters |
| 2 | Save 2 hours a day | |
| 3 | 10 Excel tricks for your boss | |
| 4 | Free planner inside |
| A | B | |
|---|---|---|
| 1 | Ad headline | Characters |
| 2 | Save 2 hours a day | 18 |
| 3 | 10 Excel tricks for your boss | 29 |
| 4 | Free planner inside | 19 |
Step by step
- Click cell B2.
- Type the formula:
=LEN(A2) - Press Enter.
- Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)
The same formula in other languages
- English LEN
- Español LARGO
- Português NÚM.CARACT