ENDSWITH
Returns true if a property or string ends with a value, and returns false otherwise.
Syntax
=ENDSWITH(value, test)
Arguments
| Argument | Type | Description |
|---|---|---|
| value | String | The value to check for the ending string |
| test | String | The value to look for |
Examples
=ENDSWITH("xyz", "x") → false
Tests whether the string "xyz" ends with "x".
=ENDSWITH("xyz", "a") → false
Tests whether the string "xyz" ends with "a".
=ENDSWITH("xyz", "z") → true
Tests whether the string "xyz" ends with "z".
=ENDSWITH(@"Property 1", "abc") → false
Tests whether the shape data property @"Property 1" ("abcdef") ends with the string "abc".
=ENDSWITH(@"Property 1", "def") → true
Tests whether the shape data property @"Property 1" ("abcdef") ends with the string "abc".
Updated 9 months ago