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

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).


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

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999