The LEN worksheet function in Excel returns the number of characters in a text string.
LEN worksheet function
Here is the syntax of the LEN function.
Syntax
=LEN(reference)
Arguments
Reference – A text string or cell range.
Example(s)
Example 1
This example uses the LEN function from a cell reference. Below is the result.As a result of the above LEN function, 9 is returned.
Example 2
So, you can also type a text string directly into the function. Thus, LEN(“Standards”) will return 9.
Example 3
Also, you can find the lengths of a group of cells, in one function. So, in the above LEN function, we try to find the lengths of multiple cells. It should automatically show the length for every cell in that range of A3 to A23. See the results below.Results of the LEN function using a cell range.