=LISTITEMRIGHT
The =LISTITEMRIGHT() function searches a semicolon separated text list and returns the specified number of rightmost characters from each list entry.
Syntax
Section titled “Syntax”=LISTITEMRIGHT(NumberOfCharactersToReturn; SemicolonSeparatedList)Parameters
Section titled “Parameters”-
NumberOfCharactersToReturn – The number of characters to return from the right side of each list entry.
-
SemicolonSeparatedList – The semicolon-separated list of text values to process.
How It Works
Section titled “How It Works”-
Evaluates each item in the provided list.
-
Extracts the specified number of rightmost characters from each list entry.
-
Returns a new list with the modified values.
Usage Notes
Section titled “Usage Notes”- Formula functions are case sensitive and must be written in ALL CAPS.
Example
Section titled “Example”=LISTITEMRIGHT(4; ListEntry1; Entry2; FindText3; FindText4; LastEntry5)Returns
try1; try2; ext3; ext4; try5
Keywords
Section titled “Keywords”LISTITEMRIGHT, right characters, string manipulation, text extraction, semicolon-separated list, list processing, workflow formulas, formula function