How to Count Characters in Excel (Length of Each Cell)
LEN gives you the length, but you have to type it, copy it down, and paste as values to keep it. Add a column with the character count of every row's first cell in a single click.
Last updated: August 2026
| Text | Characters | |
|---|---|---|
| Hello | → | 5 |
| New York | → | 8 (spaces counted) |
Why LEN is more work than it looks
LEN is the right function, but it's a live formula: you type =LEN(A2), drag or copy it down the whole column, and then — because a formula recalculates and breaks if the source moves — paste as values to keep a stable count. For a quick field-length check or a data-quality pass, that's three steps you repeat every time.
The 1-click way — Tellsheet's Count Characters
Select the column and run Count Characters. Tellsheet adds a new column holding the character length of every row's first cell, written as a real number you can sort and compare — no LEN to type, copy down, or paste as values. Your original text is left untouched. Pairs with Count Words and Extract Text.
Frequently asked questions
Isn't LEN enough?
LEN gives the length, but you still type it, copy it down, and paste as values to keep it. Count Characters does all that in one click.
Where does the count go?
Into a new column beside your text, holding each row's character length.
Is it a real number?
Yes — an ordinary number you can sort, filter, and compare to a field limit, not a live formula.
Does it change my text?
No — it only reads each first cell and writes the length alongside; the source is untouched.
Related Excel guides
Count characters without a formula
Count Characters adds a column with each cell's length in one click — a real number, no LEN to type, copy, and convert.
Get Tellsheet free See pricing