Syntax: STRLEN(argumentlist)
argumentlist = any combination of numbers, cells, or ranges
STRLEN returns the total length of all the strings in its argument list. It differs from LENGTH in that it can take multiple arguments, but more significantly, it returns the length of the formatted contents of a cell, even if it contains a numeric argument.
Example:
STRLEN(``PHYSICS'') = 7
STRLEN(B1) = 34, where B1 = ``Engineering Scientific Spreadsheet''
STRLEN(A1) = 10, where A1 contains the value formatted as currency with two decimal places so that it appears on screen as $1,000.00 (plus a trailing blank).
Excel function: N/A