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.
Image Credit: Image courtesy of Microsoft

Step 1

Start the LEN function.
Image Credit: Image courtesy of Microsoft

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.

Step 2

Choose the target cell.
Image Credit: Image courtesy of Microsoft

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.

Step 3

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

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.

Step 4

Add an AutoSum.
Image Credit: Image courtesy of Microsoft

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

Step 5

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

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."

Tip

LEN counts letters, numbers and punctuation, including spaces.

Click a row or column header while creating the SUMPRODUCT and LEN formula to count the characters in an entire row or column.

Warning

SUMPRODUCT and LEN can't count every cell on an entire worksheet. Even if you place the formula on a separate sheet to avoid a circular reference, Excel cannot process the function on an entire sheet simultaneously. Instead, stick to counting smaller selections of rows or columns.

references