=LISTITEMPREPEND
The =LISTITEMPREPEND() function loops over a semicolon separated text list and prepends the specified text to each list entry.
Syntax
Section titled “Syntax”=LISTITEMPREPEND(PrependText; SemicolonSeparatedList)Parameters
Section titled “Parameters”-
PrependText – The text to prepend to each list entry.
-
SemicolonSeparatedList – The semicolon-separated list of text values to modify.
How It Works
Section titled “How It Works”-
Evaluates each item in the provided list.
-
Prepends the specified text to the beginning of each list entry.
-
Returns a new list with the modified entries.
Usage Notes
Section titled “Usage Notes”- Formula functions are case sensitive and must be written in ALL CAPS.
Example
Section titled “Example”=LISTITEMPREPEND(MoreText; ListEntry1; Entry2; FindText3; FindText4; LastEntry5)Returns
MoreTextListEntry1; MoreTextEntry2; MoreTextFindText3; MoreTextFindText4; MoreTextLastEntry5
Keywords
Section titled “Keywords”LISTITEMPREPEND, prepend text, string manipulation, semicolon-separated list, list processing, workflow formulas, formula function