It returns the number of characters in a text string.
The syntax of the function is the following:
LEN(text)
text: The text whose length you want to find. Spaces count as characters.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the LEN function:
In column B calculate the length of the words in column A.