ISTEXT
Checks if cell contains text to which value is referring
Checks if cell contains text to which value is referring
Syntax of Excel Istext formula:
=ISTEXT(value)
In words:
=Confirms if cell contains text(to which this value is referring)
=ISTEXT(“September 22”) will return TRUE
=ISTEXT(HS76) will return TRUE if the data contained in that cell is of text nature.