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.