Count characters in an Excel cell
Here we show you which formula you can use to count the characters in an Excel cell.
Count characters in an Excel cell
The basic formula is: "= length (A1)". The values in parentheses indicate the cell in which the characters are to be counted.
- Click on an empty cell and enter the formula "= length (A1)". In this case, the characters in cell "A1" are counted.
- Confirm by pressing [Enter].
- The number of characters in the reference cell then appears in the cell in which you entered the formula.
Microsoft Office 2007 was used for this practical tip. With older or newer versions this trick works the same way! General instructions on how to use Excel formulas can be found here.