Excel 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, I 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 & 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 & not concerned with formatting.
LEN Function is most useful if there is a need to count characters in excel. You can check here how we have used it to add leading zeros in excel with the help of rept function. And, we also have used LEN function to convert a normal text case into sentence case.
The best part of it is that you can use it with other functions to get some dynamic results.
To learn more about Excel LEN Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.