The LEN function can be used to count the number of characters in a cell.
It can count text, numbers, special characters, non-printable characters, and spaces from a cell.
In the below example, we have used LEN function to count mobile number digits. As I have 10 digits in the cell, it has return 10 in the result.
In the below example, we have used LEN function to count letters in a cell. “Hello, World” has 10 letters with a space between and I got 11 in the result.
In the below example, “22-Jan-2016” has 11 characters, but LEN function returns 5.
The reason behind it is that LEN function counts the characters in the value of a cell and not concerned with formatting.