istext
What Does It Do?
This functions tests an entry to determine whether it is text. If the entry is text is shows TRUE. If the entry is any other type it shows FALSE.
Syntax
=ISTEXT(CellToTest)
Formatting
No special formatting is needed.
| Cell To Test | Result | |
| Hello | TRUE | =ISTEXT(D4) |
| 1 | FALSE | =ISTEXT(D5) |
| 25-Dec-98 | FALSE | =ISTEXT(D6) |
| FALSE | =ISTEXT(D7) |