Quick, clean, and to the point

Count total characters in a cell

Excel formula: Count total characters in a cell
Generic formula 

If you need to count the total characters in a cell, you can do so using the LEN function. In the generic form of the formula above, a1 represents a cell that contains text.

In the example, the formula in the active cell is:


The LEN function simply counts all characters that appear in a cell. All characters are counted, including space characters. Numbers are also counted in their raw form (i.e. number formatting is not included).

Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.