How to Count the Number of Characters in Microsoft Excel

Any time you select multiple cells in Excel 2010 or 2013, the status bar displays a few calculations, including a count of selected cells and the sum of all selected numbers. If you want to know the number of characters inside your cells, however, you need to use the LEN function. LEN only counts one cell at a time, so to add up multiple cells, either use an AutoSum or the SUMPRODUCT function.

...
Either SUMPRODUCT or an AutoSum of LEN functions produce the same result.
credit: Image courtesy of Microsoft

Step

Select a cell adjacent to the cell you want to count and type "=LEN(" without quotation marks. The LEN function counts the number of characters in a target cell.

...
Start the LEN function.
credit: Image courtesy of Microsoft
...
Choose the target cell.
credit: Image courtesy of Microsoft

Step

Click the cell that needs counting to enter its location into the formula, or type the location by hand. Press "Enter" to finish the formula and count the cells.

...
Fill in additional cells.
credit: Image courtesy of Microsoft

Step

Drag the fill handle on the cell containing LEN to fill in additional cells with the same formula, counting the characters in the corresponding adjacent cells.

...
Add an AutoSum.
credit: Image courtesy of Microsoft

Step

Select all the cells containing LEN formulas, open the "Formulas" tab and click "AutoSum" to insert a new cell with the complete character count.

...
Add multiple counts with SUMPRODUCT.
credit: Image courtesy of Microsoft

Step

Enclose a LEN function targeting multiple cells within the SUMPRODUCT function to produce a complete character count without the need for multiple individual LEN functions. To create this formula, type "=SUMPRODUCT(LEN(" without quotes, click and drag to select the target cells, close both parentheses and then press "Enter."