STRLEN(<List>)

 

Description

This function 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

 

<List>

Any combination of numbers, cells, or ranges.

 

Examples

 

STRLEN("PHYSICS") = 7

 

STRLEN(B1) = 34

Where B1 = "Engineering Scientific Spreadsheet".

 

STRLEN(A1) = 9

Where A1 contains the value formatted to two decimal places so that it appears on the screen as 1,000.00 (plus a trailing blank).