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.