Count number of characters in a cell in Excel
You can easily count the total characters in a cell with the LEN function in Excel. The total characters not only includes all letters, but also all spaces, punctuation marks and symbols in the cell.
How to count number of characters in a cell in Excel?
How to use this formula?
Supposing you have a list of cells as the below screenshot shown, and you want to count the total characters for each cell in the list, please do as follows.
1. Select a blank cell to output the result.
2. Enter the below formula into it and press the Enter key.
3. Select the first result cell, and then drag the Fill Handle to apply the formula to other cells. See screenshot:
Then you can see all characters which including the letters, numbers, symbols and spaces that appear in each cell are counted.