Jump to content

Documentation/Calc Functions/ISTEXT

From The Document Foundation Wiki


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