ISTEXT

Posted on 18-01-2020 , by: admin , in , 0 Comments

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)

Leave a comment