To determine whether the contents of the cell for the text can be used ISTEXT function, which can determine the parameters of the reference or the content of the specified cell for the text, its syntax structure: ISTEXT (value).

ISTEXT function has only one parameter value, said the content to be tested. If the content of the test for the text, will return TRUE, otherwise it will return FALSE. in the parameters of the text must be entered using double quotes, otherwise excel will not be considered text, but non-string.

1, open excel, enter any number in the form and text to do the demonstration;

2, select cell A2, enter the formula = IF (ISTEXT (A1), "is the text", "is not the text"), press the enter key;

3, to get the results of the judgment of the A1 cell;

4, select the cell B1 down Drag and drop to get other cell judgment results, the following chart.

Baidu Encyclopedia-ISTEXT function