ISTEXT function

The ISTEXT function in Excel checks if a value is text. It returns TRUE if the value is text, and FALSE if the value is not text (such as a number, date, logical value, or error).

Syntax:

ISTEXT(value)

Arguments:

• value: The value or expression you want to check. This can be a cell reference, a formula, or a direct value.

Example:

Example 1: Cell contains text

• Data in A1: "Hello"
• Formula:

  =ISTEXT(A1)
  

• Result: TRUE (since A1 contains text).

Example 2: Cell contains a number

• Data in B1: 10
• Formula:

  =ISTEXT(B1)
  

• Result: FALSE (since B1 contains a number, not text).

Example 3: Cell contains a formula that returns text

• Data in C1: ="Hello, " & "World"
• Formula:

  =ISTEXT(C1)
  

• Result: TRUE (since the formula results in the text string "Hello, World").

Example 4: Cell contains a date

• Data in D1: 01/01/2025 (date format)
• Formula:

  =ISTEXT(D1)
  

• Result: FALSE (since a date is treated as a numeric value, not text).

Example 5: Cell contains an error

• Data in E1: #DIV/0! (error from a division by zero)
• Formula:

  =ISTEXT(E1)
  

• Result: FALSE (since errors are not considered text).

Key Points:

1. Text Values: ISTEXT identifies only text values, which include letters, symbols, and numbers stored as text (e.g., "123").
2. Non-Text Values: Numbers, dates, logical values (TRUE, FALSE), and errors are not considered text, so ISTEXT will return FALSE for them.
3. Formula Results: If a formula results in a text string, ISTEXT will return TRUE for the formula result.

Use Cases:

1. Data Validation: Use ISTEXT to check if a cell contains text before performing an action:

   =IF(ISTEXT(A1), "It's Text", "Not Text")
   

2. Text Processing: To identify or separate text entries from other types of data, you can use ISTEXT in combination with other functions like IF or COUNTIF:

   =COUNTIF(A1:A10, ISTEXT)  ' Count cells with text in a range.
   

3. Conditional Formatting: Highlight cells that contain text by using ISTEXT within conditional formatting rules.