=LISTITEMLEFTOF
The =LISTITEMLEFTOF() function searches a semicolon separated text list and returns the text of each entry that is left of the specified search text. If any item does not contain the SearchForText, then nothing is returned for that list entry.
Syntax
Section titled “Syntax”=LISTITEMLEFTOF(SearchForText; SemicolonSeparatedList)Parameters
Section titled “Parameters”-
SearchForText – The text to search for within 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 the portion of the text to the left of the specified SearchForText.
-
If the search text is not found in a list entry, that entry returns nothing.
Usage Notes
Section titled “Usage Notes”- Formula functions are case sensitive and must be written in ALL CAPS.
Example
Section titled “Example”=LISTITEMLEFTOF(Entry; ListEntry1; Entry2; FindText3; FindText4; LastEntry5)Returns
List; Last
Keywords
Section titled “Keywords”LISTITEMLEFTOF, left of text, string extraction, text search, semicolon-separated list, list processing, workflow formulas, formula function