next up previous contents index
Next: SUM Up: A. Function Reference Previous: STRING   Contents   Index


STRLEN

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


next up previous contents index
Next: SUM Up: A. Function Reference Previous: STRING   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003