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. | ||||||||||