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