next up previous contents index
Next: SALARM Up: A. Function Reference Previous: ROWS   Contents   Index


S

Syntax: S(R)

R = a range

S returns the string value of the top left cell in range R, or a null string (``'') if the cell is blank or contains a numeric value.

Examples:

A1..B3 =

  A B
1 1 electrons
2 2 protons
3 3 neutrons
     

S(A1..B3) = `` ''

S(B1..B3) = ``electrons''

S(A1..Z25) = `` '', where A2 = $1,000,000.00

Excel function: N/A


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