LEN

See also A-Z Spreadsheet Function List

Description Returns the number of characters in the supplied text string.

Syntax LEN(text)

text in any text string. Spaces in the string are counted as characters.

See Also EXACT and SEARCH functions

Examples LEN(“3rd Quarter”) returns 11

         LEN(“1-3”) returns 3