LEN
What Does It Do ?
This function counts the number of characters, including spaces and numbers, in a piece of text.
Syntax
=LEN(Text)
=LEN(Text)
Formatting
No Special formatting is needed.
No Special formatting is needed.
ExampleThis 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.
second name from a text entry containing both first and second names.
