ISNONTEXT function

1 year ago

2 minutes

The ISNONTEXT function in Excel checks whether a value is not text. It returns TRUE if the value is not text (e.g., a number, date, or logical value) and FALSE if the value is text.

Syntax:

ISNONTEXT(value)

Arguments:

value: The value or expression you want to check. This can be a cell reference, a number, a date, or text.

Example:

Example 1: Cell contains text

Data in A1: "Hello"
Formula:
```
=ISNONTEXT(A1)
```
Result: FALSE (since A1 contains text).

Example 2: Cell contains a number

Data in B1: 5
Formula:
```
=ISNONTEXT(B1)
```
Result: TRUE (since B1 contains a number, not text).

Example 3: Cell contains a date

Data in C1: 01/01/2025 (date format)
Formula:
```
=ISNONTEXT(C1)
```
Result: TRUE (since C1 contains a date, which is not considered text).

Example 4: Cell contains a logical value (`TRUE`)

Data in D1: TRUE
Formula:
```
=ISNONTEXT(D1)
```
Result: TRUE (since D1 contains a logical value, not text).

Key Points:

Non-Text Values: The ISNONTEXT function returns TRUE for values that are numbers, dates, boolean values (TRUE or FALSE), and formulas (even if the result is text). It returns FALSE for any text value.
Text Values: If the value is text (e.g., words, alphanumeric combinations, or even a number formatted as text), ISNONTEXT will return FALSE.
Date and Time Values: Dates and times in Excel are considered numeric values, so ISNONTEXT will return TRUE for them.

Use Cases:

Data Validation: Use ISNONTEXT to filter or handle non-text values:
```
=IF(ISNONTEXT(A1), "Not Text", "Text")
```
Identifying Non-Text Entries: If you’re working with a list and want to find or exclude non-text data, you can apply ISNONTEXT to separate or filter those entries.

Post Views: 24