MS Excel: IsText Function
In Excel, the IsText function can be used to check for a text value.
The syntax for the IsText function is:
IsText( value )
value is the value that you want to test. If value is a text value, this function will return TRUE. Otherwise, it will return FALSE.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=IsText(A1) would return FALSE =IsText(A2) would return TRUE =IsText(A3) would return FALSE =IsText(A4) would return TRUE =IsText("techonthenet") would return TRUE