STARTSWITH

Returns true if a property or string starts with a value, and returns false otherwise.

Syntax

=STARTSWITH(value, test)

Arguments

Argument	Type	Description
value	String	The value to check for the starting string
test	String	The value to look for

Examples

=STARTSWITH("xyz", "x") → true
Tests whether the string "xyz" starts with "x".

=STARTSWITH("xyz", "a") → false
Tests whether the string "xyz" starts with "a".

=STARTSWITH("xyz", "z") → false
Tests whether the string "xyz" starts with "z".

=STARTSWITH(@"Property 1", "abc") → true
Tests whether the shape data property @"Property 1" ("abcdef") starts with the string "abc".