What is the use of Length formula?

Purpose              :   Get the length of text.

Return value     :   A number representing the lengh of the text.

Syntax                 :   =LEN (text)

Parameter list   :   text - The text for which to calculate length.

Examples of Excel Len formula:

len("Shahul Hameed") = 13

len(A1) = length of the value in cell A1

To get the length of a string, use the LEN function.