Spread Formula Reference
Formula Functions / Functions T to Z / T
In This Topic
    T
    In This Topic

    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