The Excel Spreadsheet Excelclopedia
Printable ViewExcel ISTEXT Function
Syntax
=ISTEXT(value)
Checks if the value, cell reference or formula returns text
Returns TRUE or FALSE
Returns TRUE if the value is text
Examples
| A | B | C | D | E |
| 2 | Cell references | Returned Values | ||
| 3 | Excel Wiki | =ISTEXT(C3) | TRUE | |
| 4 | 1000 | =ISTEXT(C4) | FALSE | |
| 5 | 0 | =ISTEXT(C5) | FALSE | |
| 6 | cell c6 is blank | =ISTEXT(C6) | FALSE | |
| 7 | =1701/0 | =ISTEXT(C7) | FALSE | |
| 8 | ||||
| 9 | Formulas | |||
| 10 | Excel | 2000 | =ISTEXT(B10&C10) | TRUE |
| 11 | 1701 | 0 | =ISTEXT(B11+C11) | FALSE |
| 12 | 1701 | 2 | =ISTEXT(B12/C12) | FALSE |
| 13 | 1701 | 3 | =ISTEXT(B13/C13) | FALSE |
| 14 | ||||
| 15 | ||||
| 16 | Values | |||
| 17 | =ISTEXT("abc") | TRUE | ||
| 18 | =ISTEXT("1000") | TRUE |
Categories: IS Functions