How to Use LEN Function

The LEN function is to count the number of characters including spaces in a text string.

Formula:

=LEN(text)

Explanations:

Text is required, the text string that you need to count the number of characters.

Cautions:

Spaces will be counted as characters when using the LEN function.

Example 1: How many characters in cell A2?

=LEN(A2)
The result returns 3; there are 3 characters in cell A2.

Example 2: How many characters in cell A3?

=LEN(A3)
The result returns 7; there are 7 characters in A3.

Example 3: How many characters in cell A4?

=LEN(A4)
The result returns 23; there are 23 characters in cell A4.

Download: LEN Function

Leave a Reply