Joshua earned an MBA from USF and he writes mostly about software and technology.
The Purpose of the ISTEXT Function
The ISTEXT function is one of Excel's information functions that allows one to check whether a value in a cell is a text value or not by displaying true or false as the result.
The ISTEXT Function
The ISTEXT Function Syntax
When entering the ISTEXT function it needs to be inputted into a cell like a formula. The following steps need to be taken:
- A cell is clicked in, type "=ISTEXT(".
- Add the cell reference to the cell that needs to be tested and use a follow with a closing parenthesis.
- After the formula is created, the formula can be entered.
Below you can see the syntax of the ISTEXT function.
- value - (Required) The value is the value that needs to be tested. The value can be anything that appears in a cell. It can even be an empty cell. You would expect text, errors, logical values, and numbers to be tested when using this function.
The examples below show what the ISTEXT function will return as a result when used in differing situations. Each is described briefly below:
#DIV/0 - When this function sees an error it will return a false value since errors are not seen by Excel as text values.
Sort0 - When numbers and text values are mixed together the value will always be considered a text value. This will be true even if there is only one text character so the result will be true.
Text - Text will be recognized as true because it is most definitely a text value.
1996 - Number values will be have a false results because they are not text values.
"2000" - When a number value has quotes around it, it will be recognized as text by this function. Quotes are escape characters and in the back end of Excel will be recognized any character that the quotes around them as text values.
Inserting the ISTEXT Function
The ISTEXT function can be inserted into a cell as opposed to typing it in. This can be done by first selecting the cell, then clicking on the formulas tab. Next, click on the other functions button and the information option. Select ISTEXT from the list of functions.
Select the Function
When the formula builder appears, the value argument can be added to the empty field. An immediate result will appear at the bottom of the formula builder sidebar.
After the arguments are added, the done button can be clicked for the function to be entered.
Enter the Argument in the Formula Builder
Microsoft. (n.d.). ISTEXT function. Retrieved August 3, 2022, from https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665
- How to Use the AVEDEV Function in Excel for Mac
This tutorial shows how to use the AVEDEV function in Excel.
- How to Use the CHAR Function in Excel for Mac
This tutorial shows how to use the CHAR function in Excel.
- How to Use the VALUETOTEXT Function in Excel for Mac
This tutorial shows how to use the VALUETOTEXT function in Excel.
- How to Use the BAHTTEXT Function in Excel for Mac
This tutorial shows how to use the BAHTTEXT function in Excel.
- How to Use the FISHER Function in Excel for Mac
This tutorial shows how to use the FISHER function in Excel. Examples are shown with a Mac but relevant to PC users.
To learn more about using functions in Excel I recommend use the Excel 2019 Bible book. I have been using the Excel Bible for years to improve my understanding of all aspects of this Microsoft product.
This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.
© 2022 Joshua Crowder