The Excel LEN function returns the length of a given text string as the number of characters. 

It is one the most useful excel string functions, used many times to achieve our objective. 

LEN will also count characters in numbers.  

Syntax

LEN (text)

Arguments

text - The text for which to calculate length.

It is often used with Right and Left function in MS Excel to separate First, Middle, and Last Name from a given name.

In the example, the LEN function is used to determine the number of characters in a name including spaces.

The same function also applied on numbers to count how many numbers are there in the field. If spaces or special characters or any text included it will also count them together.  

Have any questions? Write to dataentryikc@gmsil.com