IsText

Syntax

IsText(Value)

Parameters

Value. Checked value.

Description

It checks if the value is text.

Comments

It returns TRUE if value is text, otherwise it returns FALSE.

Numbers, empty cells, logical values, text, cell references, and formulas can be used as a parameter value.

Empty cells are not text ones.

Example

Formula Result Description
=IsText(C2:E9) FALSE The cell range C2:E9 does not contain text values.

See also:

Function Wizard │ Logical Functions