ISTEXT

Check a cell for the text value in Excel
Returns TRUE if the value is text

Rational

Check a cell for the text value

Description

The Excel ISTEXT function checks if a specified cell has a value in text format and returns “TRUE” when a cell contains a text value, and “FALSE” if not.

Syntax

=ISTEXT (value)

Parameters

value – Cell to check text value

Return Value

A Boolean value (TRUE or FALSE)

Key Notes

  • The ISTEXT formula returns TRUE only if the value in the cell is in text format and even a numerical value entered as text and FALSE if the value is in any other format apart from text like number, date or currency.
  • For example, =ISTEXT(B6) will return FALSE where B6 refer to a numerical value 100 and =ISTEXT(“100”) will return TRUE as the numerical value is in double quotation (“text format”).
  • The ISTEXT formula is part of IS functions that return either TRUE or FALSE, depending on the argument they’re evaluating.

For example, =ISTEXT(B11) it return TRUE as in B11 contain space. so for space it is true.

 

Keep Reading Similar Functions:

Find an error code corresponding to the error value in Excel

TYPE

The Excel TYPE function returns data type of reference cell or value of an argument. Example, =TYPE(“ABC”) return data type 2 (Text data format).

Read More »
Find an error code corresponding to the error value in Excel

ERROR.TYPE

The Excel ERROR.TYPE function returns an integer code of the corresponding error type or returns the #N/A if no error exists.

Read More »
Check a cell for non-text value in Excel

ISNONTEXT

The ISNONTEXT function checks if a specified cell has non-text value and returns “TRUE” when a cell has a non-text, and “FALSE” it contains a text value.

Read More »