Owner manual

Chapter 11 Text Functions 315
Related Topics
For related functions and additional information, see:
“MID” on page 316
“RIGHT” on page 319
“Listing of Text Functions” on page 306
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
LEN
The LEN function returns the number of characters in a string.
LEN(source-string)
 source-string: A string. source-string is a string value.
Usage Notes
The count includes all spaces, numbers, and special characters. Â
Examples
=LEN(”12345”) returns 5.
=LEN(” abc def “) returns 9, the sum of the six letters plus the leading, trailing, and separating spaces.
Related Topics
For related functions and additional information, see:
“Listing of Text Functions” on page 306
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41