Len function in excel This is also another function of text category and Len function is used to measure the length of text given in any cell in excel. Len function... measures the length of the text by counting all the characters. Along with the characters inside the len function, if any space is given in the cell or special characters, symbols or numbers, then it also counts them.
Syntax-
=Len(text)
Argument-
Text - We write here the text of the cell for which the length of the text is to be extracted, or we can also select the cell reference of the text.
How to use
LEN function in excel in hindi
As you can see in the above image that the name is written in A column and in B column we have extracted the length of the name.
After this, if you see in the image below, some special characters have also been used here. |