Excel ISTEXT Function

Excel ISTEXT Function

Summary

The Excel ISTEXT function returns TRUE when a cell contains a text, and FALSE if not. You can use the ISTEXT function to check if a cell contains a text value, or a numeric value entered as text.

Purpose

Test for a text value

Return value

A logical value (TRUE or FALSE)

Syntax

=ISTEXT (value)

Arguments

Usage notes

Use the ISTEXT function to check if value is text. ISTEXT will return TRUE when value is text.

For example, =ISTEXT(A1) will return TRUE if A1 contains "apple".

Often, value is supplied as a cell address.

ISTEXT is part of a group of functions called the IS functions that return the logical values TRUE or FALSE.

 

Excel ISTEXT Function

Summary

The Excel ISTEXT function returns TRUE when a cell contains a text, and FALSE if not. You can use the ISTEXT function to check if a cell contains a text value, or a numeric value entered as text.

Purpose

Test for a text value

Return value

A logical value (TRUE or FALSE)

Syntax

=ISTEXT (value)

Arguments

Usage notes

Use the ISTEXT function to check if value is text. ISTEXT will return TRUE when value is text.

For example, =ISTEXT(A1) will return TRUE if A1 contains "apple".

Often, value is supplied as a cell address.

ISTEXT is part of a group of functions called the IS functions that return the logical values TRUE or FALSE.