Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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:

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 »
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 »