ISTEXT function - Function returns True value if that value is text in Excel
The following article introduces you to the ISTEXT function - one of the functions in the information function group is very popular in Excel.
Description: The function returns True if the value is text. The function application to check if the value is text.
Syntax: ISTEXT (value)
Inside:
- value: The value you want to test is a text or not, is a required parameter.
Attention:
- The function returns True value if that value is text and vice versa returns function False.
- If value is blank or logical -> the function returns False value
For example:
Determine whether the values in the value are text?
- In the cell to calculate enter the formula : = ISTEXT (C6)
- Press Enter -> return value is:
- Similarly copying the formula for the remaining values results:
- Where value is a blank or logical value -> Function returns false value :
Above are instructions and some specific examples when using ISTEXT function in Excel.
Good luck!
You should read it
- ISNONTEXT function - The function returns True if the value is not a text value in Excel
- How to use the IF function in Excel
- How to use the IFS function in Excel 2016
- Save time with these text formatting functions in Microsoft Excel
- ISODD function - The function returns True if the value is an odd number in Excel
- ISFORMULA function - The function returns True if that cell refers to a cell containing a formula in Excel
- ISREF function - The function returns True if the value is a valid reference value in Excel
- CHISQ.TEST function - The function returns the independence test in Excel
- Any () function in Python
- ISNUMBER function - The function returns True if the value is numeric in Excel
- OR function in Excel, how to use the OR function, and examples
- FORECAST function - The function returns a value along a linear trend in Excel
Maybe you are interested
AMD has surpassed Intel in brand value
SQL way to count NULL and NOT NULL values in a column
Comparing Odroid-N2+ and Raspberry Pi 4: Which option offers better value?
How to receive free gifts from IObit with a total value of nearly 150,000 USD
Write a program to find duplicate values in Python
Write a program to check duplicate values in Python