=LISTITEMENDSWITH
The =LISTITEMENDSWITH() function searches a semicolon separated text list and returns the list entries that end with the specified text.
Syntax
Section titled “Syntax”=LISTITEMENDSWITH(SearchForText; SemicolonSeparatedList)Parameters
Section titled “Parameters”-
SearchForText – The text to match at the end of each list entry.
-
SemicolonSeparatedList – The semicolon-separated list of text values to search.
How It Works
Section titled “How It Works”-
Evaluates each item in the provided list.
-
Identifies list entries that end with the specified search text.
-
Returns only the matching entries.
Usage Notes
Section titled “Usage Notes”- Formula functions are case sensitive and must be written in ALL CAPS.
Example
Section titled “Example”=LISTITEMENDSWITH(Text3; ListEntry1; Entry2; FindText3; FindText4; LastEntry5)Returns
FindText3
Keywords
Section titled “Keywords”LISTITEMENDSWITH, list search, text list, string matching, ends with, semicolon-separated list, workflow formulas, formula function