=LISTJOIN
The =LISTJOIN() function accepts a semicolon separated list and returns the same list with each entry separated by the specified text. See below for a list of special keywords that can be used as item separators.
Syntax
Section titled “Syntax”=LISTJOIN(NewListItemSeparator; SemicolonSeparatedList)Parameters
Section titled “Parameters”-
NewListItemSeparator – The text or special keyword to use as a separator between list entries.
-
SemicolonSeparatedList – The semicolon-separated list of text values to join.
How It Works
Section titled “How It Works”-
Loops through each item in the provided list.
-
Inserts the specified separator between each list entry.
-
Returns the new combined list with the chosen separators applied.
Usage Notes
Section titled “Usage Notes”-
Formula functions are case sensitive and must be written in ALL CAPS.
-
Special keywords are literal and must be typed exactly as listed (e.g., ppnewline).
-
Can be used to format lists for display, reports, emails, or text files.
Example
Section titled “Example”=LISTJOIN(ppnewline; ListEntry1; ListEntry2; ListEntry3)Returns
ListEntry1
ListEntry2
ListEntry3
Special Character Keywords
Section titled “Special Character Keywords”Any text value can be used as the list separator value. Here are some keywords that can be used to represent special characters.
ppnewline = new line character
pptab = tab character
ppcrlf = carriage return / line feed
ppcr = carriage return
pplf = line feed
ppvtab = vertical tab character
ppsp = space character
Keywords
Section titled “Keywords”LISTJOIN, join list, list separator, string formatting, semicolon-separated list, special characters, workflow formulas, formula function