Navigation:  Formula Reference > Spreadsheet Formula Functions >

T

Previous pageReturn to chapter overviewNext page

 

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)

 

See Also

CHAR

ISTEXT

LEN

LOWER

UPPER