Documentation/Calc Functions/ISTEXT

    From The Document Foundation Wiki
    Other languages:


    Function name:

    ISTEXT

    Category:

    Information

    Summary:

    Determines if a specified cell or expression evaluates to text, returning TRUE if the argument is text.

    Syntax:

    ISTEXT(Value)

    Returns:

    Returns TRUE if the argument evaluates to text and returns FALSE otherwise.

    Arguments:

    Value is an expression, or a reference to a cell containing an expression, that is to be tested for text content.

    Additional details:

    • If the argument is a reference to an empty cell, ISTEXT returns FALSE.
    • ISTEXT does not propagate errors. If Value evaluates to a string, then ISTEXT returns TRUE and returns FALSE otherwise.
    • The formula =ISTEXT(X) is equivalent to =NOT(ISNONTEXT(X)).

    Examples:

    Formula Description Returns
    =ISTEXT("example pattern") Here the function returns TRUE because the argument is a text string. TRUE
    =ISTEXT(74.56) Here the function returns FALSE because the argument is a decimal number, not a string. The same result would arise for the formulas =ISTEXT(2022-01-22) and =ISTEXT(TRUE()). FALSE
    =ISTEXT(D1) where cell D1 contains the string "LibreOffice Calc". Here the function returns TRUE because the argument is a reference to a cell containing a text string. TRUE
    =ISTEXT(D2) where cell D2 is empty. Here the function returns FALSE because the argument is a reference to an empty cell. FALSE
    =ISTEXT(1/0) Here the function returns FALSE because the argument is not a string. Note that ISTEXT does not propagate the #DIV/0! that arises from the division by 0. FALSE

    Related LibreOffice functions:

    ISLOGICAL

    ISNONTEXT

    ISNUMBER

    ODF standard:

    Section 6.13.25, part 2

    Related (or similar) Excel functions:

    ISTEXT