LEN Function (Functions in Excel)

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.

Related Posts by Categories