These docs are for v1.0. Click to read the latest docs for v1.2.

ISTEXT / ISSTRING

Returns true if the specified value is a text value.

Syntax

=ISTEXT(value)

=ISSTRING(value)

Arguments

ArgumentTypeDescription
valueAnyThe value to test

Examples

=ISTEXT(1)false
Tests whether the number 1 is a text value.

=ISSTRING("Name")true
Tests whether the string "Name" is a text value.

=ISTEXT(@"Property 1")true
Tests whether the shape data property @"Property 1" ("Hello") is a text value.