Spread WinRT Documentation
Spread WinRT Documentation / Formula Reference / Formula Functions / ISTEXT
In This Topic
    ISTEXT
    In This Topic

    Summary

    This function tests whether a value, an expression, or contents of a referenced cell has text data.

    Syntax

    ISTEXT(cellreference)

    ISTEXT(value)

    ISTEXT(expression)

    Arguments

    Specify a cell reference, a numeric or text value, or an expression for the argument.

    Remarks

    Use this function to test the contents of a cell, a numeric or text value directly, or a function or expression.

    If the data type of the argument is text, this function returns TRUE. If the data type of the argument is not text, this function returns FALSE. If the argument refers to an empty cell, this function returns FALSE.

    Data Types

    Accepts any data type for an argument. Returns Boolean (TRUE or FALSE) data.

    Examples

    ISTEXT(B3)

    ISTEXT(R1C2)

    ISTEXT("Total") gives the result TRUE

    ISTEXT(12) gives the result FALSE

    See Also