# ISTEXT

## 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.

=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.

### 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.

### 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).

### 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.