Skip to main content

How to Use the ISTEXT Function in Excel for Mac

Joshua earned an MBA from USF and he writes mostly about software and technology.

The ISTEXT function is one of Excel's information functions.

The ISTEXT function is one of Excel's information functions.

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 illustration above shows the ISTEXT function typed into a cell. Automated help tips appear as part of the function editing process.

The illustration above shows the ISTEXT function typed into a cell. Automated help tips appear as part of the function editing process.

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:

  1. A cell is clicked in, type "=ISTEXT(".
  2. Add the cell reference to the cell that needs to be tested and use a follow with a closing parenthesis.
  3. After the formula is created, the formula can be entered.

Below you can see the syntax of the ISTEXT function.

=ISTEXT(Value)

  • 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.

Example

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.

Scroll to Continue

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.

how-to-use-the-istext-function-in-excel-for-mac

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

The ISTEXT function is selected from a list of information functions.

The ISTEXT function is selected from a list of information functions.

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

The formula builder for the ISTEXT function guides you to use the function appropriately while also displaying the what the function will return when it is executed.

The formula builder for the ISTEXT function guides you to use the function appropriately while also displaying the what the function will return when it is executed.

References

Microsoft. (n.d.). ISTEXT function. Retrieved August 3, 2022, from https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665

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

Related Articles