Exceljet

Quick, clean, and to the point

Count total characters in a cell

Excel formula: Count total characters in a cell
Generic formula 
=LEN(a1)
Summary 

To count the total characters in a cell, you can use the LEN function. In the example shown, the formula in cell C5, copied down, is:

=LEN(B5)

The result in C5 is 3; the total number of characters in cell B5.

Explanation 

The LEN function is fully automatic. In the example, the formula in the active cell is:

=LEN(B5)

The LEN function simply counts all characters that appear in a cell. All characters are counted, including space characters, as you can see in cell C9.

Numbers

Numbers in Excel (including dates, times, currency, etc.) are often formatted with a number format. It's important to understand that the characters that make up numbers are counted in their raw form (i.e. number formatting is not included). For example, because Excel dates are serial numbers, the result in cell C11 is 5, since the date in B11 is is actually the number 42005.

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

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.