=LISTASLINES
The =LISTASLINES() function converts a semicolon-separated list into a multiline string, with each list item on a separate line.
Syntax
Section titled “Syntax”=LISTASLINES(SemicolonSeparatedList)or for plain text line breaks:
=LISTASLINES(ppcrlf; SemicolonSeparatedList)Parameters
Section titled “Parameters”-
SemicolonSeparatedList: The list of values separated by semicolons
-
ppcrlf (optional): Use this keyword as the first parameter to replace the default HTML
<br/>line break with a carriage return / line feed suitable for plain text
How It Works
Section titled “How It Works”-
Converts each item in a semicolon-separated list into its own line
-
By default, lines are separated with
<br/>for HTML display -
Use ppcrlf to generate plain text line breaks instead of HTML
-
Works with both static lists and field tokens containing semicolon-separated values
Usage Notes
Section titled “Usage Notes”-
Line break behavior depends on whether ppcrlf is specified
-
Formula functions are case sensitive and must be in ALL CAPS
Example
Section titled “Example”=LISTASLINES(ListEntry1; ListEntry2; ListEntry3)Returns
ListEntry1
ListEntry2
ListEntry3
Keywords
Section titled “Keywords”LISTASLINES, multiline text, semicolon list, text functions, line break, HTML line break, carriage return, formula function, calculated value