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)