Return the logical value TRUE if the cell contains any text.
=ISTEXT(value)
Return the logical value TRUE if the cell contains any text and FALSE if the cell includes numbers, dates, times, errors, formulas that return non-text results or an empty cell.
ISTEXT is part of the collective IS functions which check specified values and return TRUE or FALSE depending on the outcome. The IS functions are useful for testing the outcome of a calculation and can be combined with the IF function in formulas to locate errors or get information about a value before performing another calculation.
The collective of IS functions are ISBLANK(value), ISERR(value), ISERROR(value), ISLOGICAL(value), ISNA(value), ISNONTEXT(value), ISNUMBER(value), ISREF(value) and ISTEXT(value).
To test the reverse of the function (e.g. to test if a cell does NOT contain an error), combine the ISTEXT and NOT functions - =NOT(ISTEXT(C7)) where cell reference C7 is the value being tested.
ISTEXT syntax requires a value to test. The value argument can be a blank (empty) cell, error, logical value, text, number, reference value, or a name referring to any of these.
ISTEXT with text strings or numerical values.
In the examples below, the ISTEXT function is used to determine whether cells contain text or not.
Use the ISTEXT function to return the logical value TRUE if a cell contains text.
Syntax
ISTEXT(value)
The ISTEXT function requires 1 value argument:
- value. Required. Generally a cell reference.
Try it now!
- Select the answer from the drop down lists in the grey cells.
Scope
ISTEXT can be used on its own to determine whether a cell contains a TRUE or FALSE statement or combined within a formula to test a value prior to performing additional operations.
|
=ISTEXT(1/0) || result is FALSE as divide by zero triggers a #DIV/0! error not a text statement. |
|
=ISTEXT(C7) || result is FALSE if cell reference C7 contains a number, date or time. |
|
=ISTEXT(C7) || result is TRUE if cell reference C7 contains a number written as text. |
|
=ISTEXT(C7) || result is TRUE if cell reference C7 contains text. |
|
=IF(ISTEXT(C7),"Cell contains text","Cell does not contain text") || when ISTEXT is TRUE, the result is "Cell contains text", otherwise it is "Cell does not contain text" |
Caveats
- Values that have been concatenated using the ampersand (&) are represented as text so will return a TRUE statement to the ISTEXT function.
- Value arguments are not converted. Numeric values enclosed in double quotation marks are treated as text (e.g. "22"). Any IS functions requiring numeric values will therefore return a FALSE if the value is a text string.
Related Functions
- ISBLANK returns the logical value TRUE if a cell is blank or empty.
- ISERR returns the logical value TRUE for any error type except the #N/A error.
- ISERROR returns the logical value TRUE for any error type.
- ISLOGICAL returns the logical value TRUE if the cell contains either a TRUE or FALSE statement.
- ISNA returns the logical value TRUE if a cell contains the #N/A error
- ISNONTEXT returns the logical value TRUE if the cell contains any value that is not text.
- ISNUMBER returns the logical value TRUE if the cell contains a number.
- ISREF returns the logical value TRUE if the cell contains a reference.
- ISTEXT returns the logical value TRUE if the cell contains any text.
Functions Category