The LEN function is to count the number of characters including spaces in a text string.
Text is required, the text string that you need to count the number of characters.
Spaces will be counted as characters when using the LEN function.
Example 1: How many characters in cell A2?
The result returns 3; there are 3 characters in cell A2.
Example 2: How many characters in cell A3?
The result returns 7; there are 7 characters in A3.
Example 3: How many characters in cell A4?
The result returns 23; there are 23 characters in cell A4.