LEN

Posted on 24-01-2020 , by: admin , in , 0 Comments

len

TextLength 
Alan Jones10 =LEN(C4)
Bob Smith9 =LEN(C5)
Carol Williams14 =LEN(C6)
Cardiff7 =LEN(C7)
ABC1236 =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 Williams6 =FIND(” “,C24)
  This is the position of the space.



Carol Williams8 =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.

share:

Leave a comment