This function returns the text in a specified cell.
Syntax
T(value)
Arguments
The argument is any cell reference.
Remarks
If the cell contains text, this function returns text. If the cell contains a number, this function returns an empty string.
Data Types
Accepts cell reference. Returns string data.
Examples
T(B3) If B3 contains "Test" then this function returns "Test".
T(R3C2)
T(A1)
Version Available
This function is available in product version 2.0 or later.
See Also
LEN | ISTEXT | CHAR | UPPER | LOWER | Text Functions