What is the ISTEXT function in Excel?
The ISTEXT function is one of the Information functions of Excel.
It Checks whether a value is text, and returns TRUE or FALSE.
We can find this function in Information of insert function Tab.
How to use ISTEXT function in excel
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select Information category.
5. Select ISTEXT function
6. Then select ok.
7. In the function arguments Tab you will see ISTEXT function.
8. Value section is the value you want to be tested. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value.
9. You will see the results in the formula result section.
Examples of ISTEXT function in Excel
ISTEXT related functions
- Use ISBLANK function to check whether a reference is to an empty cell, and return TRUE or FALSE.
- Use ISREF function to check whether a value is a reference, and return TRUE or FALSE.
- Use ISFORMULA function to check whether a reference is to a cell containing a formula.
- Use ISNONTEXT function to check whether a value is not text, and return TRUE or FALSE.
