ISTEXT
Formulas / ISTEXTTest if a cell contains a text value.
ISTEXT(value)
- value - required argument to test
Examples
The ISTEXT function will return the text "apple" when used with the argument "apple". When the ISTEXT formula is used with this argument, it will detect the text value and return TRUE.
The ISTEXT function will return FALSE when used with the argument A1. This is because A1 is a reference to a cell and not a text value.
The ISTEXT function will return TRUE when used with the argument A1 & "hello". This is because the ampersand (&) is the concatenation operator in Sourcetable, so the string A1 & "hello" is a text value.
The ISTEXT function will return TRUE when used with the argument 10 & "apples". This is because 10 apples is a text value.
Summary
The ISTEXT function tests a value and returns TRUE or FALSE depending on the outcome. This can be useful for locating errors in formulas when combined with the IF function.
- The ISTEXT function can be used to check if a cell contains a text value or numeric value entered as text. It returns TRUE if the cell contains a text value and FALSE if it contains any other value other than NULL or 0.
Need help with Formulas?
Frequently Asked Questions
What is the ISTEXT function?
What values does the ISTEXT function accept?
What does the ISTEXT function return?
- The ISTEXT function returns TRUE if the value argument is a text value.
- The ISTEXT function returns FALSE if the value argument is a reference to another value.
When should I use the ISTEXT function?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.