.

LEN Function Dictionary

Function Dictionary Function Examples Function Categories

LEN            
 
Text Length
Alan Jones 10  =LEN(C4)
Bob Smith 9  =LEN(C5)
Carol Williams 14  =LEN(C6)
Cardiff 7  =LEN(C7)
ABC123 6  =LEN(C8)
What Does It Do ?            
This function counts the number of characters, including spaces and numbers, in a piece of text.
Syntax              
=LEN(Text)
Formatting            
No Special formatting is needed.
Example              
This example shows how the =LEN() function is used in a formula which extracts the
second name from a text entry containing both first and second names.
Original Text
Carol Williams 6  =FIND(" ",C24)
This is the position of the space.
Carol Williams 8  =LEN(C24)-FIND(" ",C24)
This is the length of the second name.
Calculated by taking the overall length of the complete
name and subtracting the position of the space.
 =RIGHT(C24,LEN(C24)-FIND(" ",C24))
This is just the second name.
Calculated by using the =RIGHT() function to extract
the rightmost characters up to the length of
the second name.

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download