Back to Class Index
STRLEN(argumentlist)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. Parameters argumentlist Any combination of numbers, cells, or ranges Examples 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). |