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

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