Buzz
This article introduces you to the ISTEXT function – one of the widely used information functions in Excel.
Description: Returns True if the value is text. Apply this function to check whether the value is textual or not.
Syntax: ISTEXT(value)
In this context:
- value: The value you want to check if it's text or not, is a mandatory parameter.
Note:
- The function returns True if the value is text, and conversely, it returns False.
- If value is empty or logical -> the function returns False
Example:
Determine if the values in value are text or not?
- In the cell where you want to calculate, enter the formula: =ISTEXT(C6)
- Press Enter -> the returned value is:
- Similarly, copy the formula for the remaining values to get the result:
- In case value is empty or logical -> the function returns False:
Here is the guide and some specific examples when using the ISTEXT function in Excel.
Wishing you all success!
