=LISTITEMSTARTSWITH
The =LISTITEMSTARTSWITH() function searches a semicolon separated text list and returns all the entries that start with the specified text.
Syntax
Section titled “Syntax”=LISTITEMSTARTSWITH(SearchForText; SemicolonSeparatedList)Parameters
Section titled “Parameters”-
SearchForText – The text to match at the beginning of each list entry.
-
SemicolonSeparatedList – The semicolon-separated list of text values to evaluate.
How It Works
Section titled “How It Works”-
Evaluates each item in the provided list.
-
Returns only the entries that begin with the specified search text.
-
Entries that do not match the search text at the start are ignored.
Usage Notes
Section titled “Usage Notes”- Formula functions are case sensitive and must be written in ALL CAPS
Example
Section titled “Example”=LISTITEMSTARTSWITH(FindText; ListEntry1; Entry2; FindText3; FindText4; LastEntry5)Returns
FindText3; FindText4
Keywords
Section titled “Keywords”LISTITEMSTARTSWITH, starts with text, string filtering, text search, semicolon-separated list, list processing, workflow formulas, formula function