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