Excel
ISTEXT function in Excel
Returns TRUE if the value is text
=ISTEXT(value)ISTEXT syntax and parameters
One argument, one required.
- valueanyRequired
The value that you want tested. The value argument can be a blank (empty cell), error, logical value, text, number, or reference value, or a name referring to any of these.
ISTEXT examples
Formulas you'll actually reuse.
Flag an amount stored as text — it won't sum:
=ISTEXT(C2)Result
FALSEHow many amounts in the column are text:
=SUMPRODUCT(--ISTEXT(C2:C200))Result
3
ISTEXT in Google Sheets
Same name — your formula ports as-is.
Try ISTEXT in the playground
Edit the example — nothing to install.
Preloaded with the ISTEXT formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- CELLReturns information about the formatting, location, or contents of a cellThis function is not available in Excel for the web.InfoGoogle Sheets
- ERROR.TYPEReturns a number corresponding to an error typeInfoGoogle Sheets
- INFOReturns information about the current operating environmentThis function is not available in Excel for the web.InfoNo Google Sheets equivalent
- ISBLANKReturns TRUE if the value is blankInfoGoogle Sheets
- ISERRReturns TRUE if the value is any error value except #N/AInfoGoogle Sheets
- ISERRORReturns TRUE if the value is any error valueInfoGoogle Sheets