The ISNONTEXT function in Google Sheets is used **when you need to determine whether the value of a cell is a non-textual value.**

With this function, the value returned is TRUE if the value is non-textual and FALSE if it is considered text. Non-textual values include numbers, dates, and errors.

##### Table of Contents

The rules for using the `ISNONTEXT`

function in Google Sheets are as follows:

- The function requires a single argument, the value to be determined as non-textual.
- The function then outputs a Boolean value that indicates whether the given input is non-textual.

Let’s take a quick look at an example of when we can apply this function.

When handling user-input, we may encounter cases where values are non-textual. For example, if I were to set up a list of books, it’s possible that input for George Orwell’s “1984” may be treated as a numeric value rather than as text. It might be useful to detect such instances in your worksheet.

With the `ISNONTEXT`

function, it’s easy to flag values in your worksheets that are not considered text values.

This use-case is just one way to use the `ISNONTEXT`

function in Google Sheets. The function can be used to validate any kind of data that must be text-only, such as names and locations.

Now that we’ve seen when to use the `ISNONTEXT`

function, let’s look at how we can start using it and later work on an actual sample spreadsheet.

**The Anatomy of the ISNONTEXT Function**

The syntax of the `ISNONTEXT`

function follows the form:

**=ISNONTEXT(value)**

Let’s go through each element of the formula and understand what each term means:

**=**the equal sign is how we indicate the start of a Google Sheets function.**ISNONTEXT()**is our`ISNONTEXT`

function. It checks whether the value provided is non-textual.**value**refers to the value we’ll be verifying as non-textual.- The function is the equivalent of using
`=NOT(ISTEXT(value))`

- Empty strings are considered text as well.
- Nonprinting characters and whitespace count as text.
- The function is often used together with the IF function to make conditional statements.

**A Real Example of Using ISNONTEXT Function**

Let’s check out an example of the `ISNONTEXT`

function being used in a Google Sheet spreadsheet.

In the example below, we have sample user input. Column C shows us which value is non-textual, and which is not. Numeric, Boolean, and date values will result in `ISNONTEXT`

returning a value of TRUE.

Notice that cell **A3** may look numeric, but it is written as a string. Similarly, cell **A8** looks like a date value, but Google Sheets interprets it as a string since it is missing the year.

The values in Column C can be obtained by using the following formula:

=ISNONTEXT(A2)

We can also use the `ISNONTEXT`

function in Google Sheets to help with logical tests. For example, in the table below, we added an `IF`

statement that relies on the output of our `ISNONTEXT`

function. If data found in Column A is not text, Column C will return “Invalid Name provided”, otherwise it will return “OK!”

To retrieve the values in Column C, we can use the following conditional statement:

=IF(ISNONTEXT(A2),"Invalid Name provide","OK!")

You can make your own copy of the spreadsheets above using the link I have attached below.

If you’re ready to use the `ISNONTEXT`

function in Google Sheets, we can start writing it ourselves!

**How to Use ISNONTEXT Function in Google Sheets**

- To start using the
`ISNONTEXT`

function, we must select a cell to output our result. In this example, we can start with cell**C2**in the first row of our dataset.

- Next, we just need to type the equal sign ‘
**=**‘ to mark the beginning of the function, followed by ‘**ISNONTEXT(**‘. - A tooltip box will appear with hints on how to use the
`ISNONTEXT`

function. We can minimize this box by clicking on the arrow found on the top-right-hand corner.

- The next step is to type in our argument into the function. In this example, we’ll be verifying cell
**A2**first.

Afterward, simply hit**Enter**on your keyboard to let the function evaluate.

- Finally, we can see that the formula works. We can drag down the formula to apply it to the rest of our column!

**Frequently Asked Questions (FAQ)**

**Why does my formula return FALSE even if no text is present in the cell?**

It’s possible that the cell being referenced has whitespace on it. Nonprinting characters and whitespace count as text, even though the cell may appear empty.**What happens if the formula tries to check an empty cell?**

The`ISNONTEXT`

function treats empty cells as non-textual. A reference to an empty cell will return TRUE.

That’s all you need to know on how to use the `ISNONTEXT`

function in Google Sheets. This step-by-step guide shows how simple it is to use the function to determine if a given cell has a non-textual value.

You can now use the `ISNONTEXT`

functions in Google Sheets together with the various other Google Sheets formulas available to set up powerful worksheets that can fit any use-case you can think of.

Stay notified of new guides like this by subscribing to our newsletter!