Clean up text
Count the characters in a cell
=LEN(A2)How it works in Excel
- LEN counts every character in A2, including spaces.
- If two values look the same but differ in LEN, one has a hidden space.
The idea in general
It measures how long a piece of text is.
What I assumed
- The text is in A2.
Check the result on your own data before relying on it.