The Excel Istext function tests if a supplied value is text, and if so, returns TRUE; Otherwise, the function returns FALSE.
The syntax of the function is:
Where the supplied value argument is the value or expression to be tested.
The following spreadsheet shows examples of the Excel Istext function:
|
Formulas:
|
Results:
|
For further details and examples of the Excel 'Is' functions, see the Microsoft Office website.