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.