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. Open the spreadsheet that contains the characters you want to count.

Table of Contents

Counting Characters in One Cell
Counting Characters in Multiple Cells

Method 1 of 2:

Counting Characters in One Cell

Open the spreadsheet that contains the characters you want to count.
Click an empty cell. This is the cell where the number of characters will appear.
Type =LEN(cell name). Replace 'cell name' with name of the cell you want to count.
1. For example, if you want to count the characters in cell C4, the formula should say =LEN(C4)
Press ↵ Enter or ⏎ Return. The number of characters in the cell now replaces the formula.

Method 2 of 2:

Counting Characters in Multiple Cells

Open the spreadsheet that contains the characters you want to count.
Click an empty cell. This is the cell where the number of characters will appear.
Type =SUMPRODUCT(LEN(Cell1:Cell2)). Replace 'Cell1' with first cell in the range you want to count, and 'Cell2' with the last in the range.
1. For example, if you want to count the characters in cells C2 through C51, the formula should say =SUMPRODUCT(LEN(C2:C51))
Press ↵ Enter or ⏎ Return. The number of characters in the specified range now appears in the cell.

You've just finished reading the article "How to Count Characters in Excel on PC or Mac" edited by the TipsMake team. You can save how-to-count-characters-in-excel-on-pc-or-mac.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

Lesley Montoya

Update 04 March 2020

« PREV : How to Block...

How to Set Up Touch... : NEXT »