Count Total Number of Characters in a Cell in Excel

← PrevNext →

You can use the LEN() function in Excel to count the total number of characters in a cell in your worksheet. The LEN (or the length) function takes a parameter (or argument), which can be a string or address of a cell.

Count total number of Characters in a Cell in Excel

LEN Syntax

LEN(text)

How do you use it? Type or enter the = sign in a cell, followed by the function LEN() with a text or a string of values. For example,

=LEN("I am Arun Banik")

It will return 15. Remember, the values are inside two double quotes.

Count total Characters in a Cell

Now, to count the total characters in a Cell, simply provide the address of the cell as parameter to the function. See the image above.

Let’s assume, I have a value Advanced Computer Materials in cell B3, the formula to get the total characters in the cell would be,

=LEN(B3)

The result will be 28, all characters along with a two spaces.

Note: The LEN will return total number of characters (alphabets, numbers, special characters etc.) including spaces.

Using LEN with other Functions

The LEN() function can also be used along with other functions. For example,

=SUMPRODUCT(LEN(B2:B10))

Here, I am trying to get the total count of all the characters in the range B2:B10 (again, see the above image).

Yes, if it’s a range of cells for which you want to count the total characters, then you’ll have to use LEN along with SUMPRODUCT function.

Must read: How to count total number of Words in a Cell or Range in Excel

Using LEN with IF function

You can use the LEN with IF function. For example,

=IF(LEN(B8) > 10, "too many characters")

The above formula will check if number of characters in cell B8 is greater than 10, then show a message.

Well, that’s it. Thanks for reading.

← PreviousNext →


Like this Article? Subscribe now, and get all the latest articles and tips, right in your inbox.
Delivered by FeedBurner