=LISTITEMAPPEND
The =LISTITEMAPPEND() function loops over a semicolon-separated list and appends the specified text to each list entry.
Syntax
Section titled “Syntax”=LISTITEMAPPEND(AppendText; SemicolonSeparatedList)Parameters
Section titled “Parameters”-
AppendText
The text to append to each item in the list. -
SemicolonSeparatedList
The list whose entries will each receive the appended text.
How It Works
Section titled “How It Works”-
Reads the input as a semicolon-separated list
-
Iterates through each list entry one by one
-
Appends the specified text to the end of every entry
-
Returns a new semicolon-separated list with the updated values
Usage Notes
Section titled “Usage Notes”-
The original list is not modified; a new list is returned.
-
Appended text is added exactly as provided (no spacing added automatically)
-
Useful for building URLs, suffixes, labels, or standardized text values
-
Formula functions are case sensitive and must be in ALL CAPS
Example
Section titled “Example”=LISTITEMAPPEND(MoreText; ListEntry1; Entry2; FindText3; FindText4; LastEntry5)Returns
ListEntry1MoreText; Entry2MoreText; FindText3MoreText; FindText4MoreText; LastEntry5MoreText
Keywords
Section titled “Keywords”LISTITEMAPPEND, append list items, semicolon list, list transformation, text append, list functions, formula function, calculated value