How to Count Characters in Excel on PC or Mac


This wikiHow teaches you how to find the number of characters in a cell or group of cells using Microsoft Excel.

Part 1
Counting Characters in One Cell

Counting Characters in One Cell on How to Count Characters in Excel on PC or Mac

1

Counting Characters in One Cell on How to Count Characters in Excel on PC or Mac

2
This is the cell where the number of characters will appear.

Counting Characters in One Cell on How to Count Characters in Excel on PC or Mac

3
Replace “cell name” with name of the cell you want to count. For example, if you want to count the characters in cell C4, the formula should say =LEN(C4)

Counting Characters in One Cell on How to Count Characters in Excel on PC or Mac

4
The number of characters in the cell now replaces the formula.

Part 2
Counting Characters in Multiple Cells

Counting Characters in Multiple Cells on How to Count Characters in Excel on PC or Mac

1

Counting Characters in Multiple Cells on How to Count Characters in Excel on PC or Mac

2
This is the cell where the number of characters will appear.

Counting Characters in Multiple Cells on How to Count Characters in Excel on PC or Mac

3
Cell2)). Replace “Cell1” with first cell in the range you want to count, and “Cell2” with the last in the range. For example, if you want to count the characters in cells C2 through C51, the formula should say =SUMPRODUCT(LEN(C2:C51))

Counting Characters in Multiple Cells on How to Count Characters in Excel on PC or Mac

4
The number of characters in the specified range now appears in the cell.