Background
As the name suggests LEN (to be read as LENGTH) function counts number of characters in given text. It is simpleast function with only single parameter.
Syntax
=LEN(source_text)
1
source_text
Text / Cell address which contains the text
Text / Cell address which contains the text
Example
HR department is compiling excel data of employees which will be pushed to database. Database has imposed limit of 63 characters for name and we want to check if the name Salman Salim Khan meets that crieteria. So we want excel to display total number of characters in this name. So formulation of LEN function would be as displayed below:
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |
| S | a | l | m | a | n | S | a | l | i | m | K | h | a | n |
Note
- Space will also be counted as character
