=LISTITEMRIGHTOF
The =LISTITEMRIGHTOF() function searches a semicolon separated text list and returns the text of each list entry that is right of the specified SearchForText value. If any item does not contain the SearchForText value, then nothing is returned for that list entry.
Syntax
Section titled “Syntax”=LISTITEMRIGHTOF(SearchForText; SemicolonSeparatedList)Parameters
Section titled “Parameters”-
SearchForText – The text to search for in each list entry.
-
SemicolonSeparatedList – The semicolon-separated list of text values to evaluate.
How It Works
Section titled “How It Works”-
Checks each item in the provided list for the specified search text.
-
Returns only the portion of the text that comes after the search text in each list entry.
-
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”=LISTITEMRIGHTOF(FindText; ListEntry1; Entry2; FindText3; FindText4; LastEntry5)Returns
3; 4
Keywords
Section titled “Keywords”LISTITEMRIGHTOF, right of text, string extraction, text search, semicolon-separated list, list processing, workflow formulas, formula function