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".
Updated 8 months ago