Text.Combine
Syntax
Text.Combine(texts as list, optional separator as nullable text) as text
About
Returns the result of combining the list of text values, texts
, into a single text value. An optional separator used in the final combined text may be specified, separator
.
Example 1
Combine text values "Seattle" and "WA".
Usage
Text.Combine({"Seattle", "WA"})
Output
"SeattleWA"
Example 2
Combine text values "Seattle" and "WA" separated by a comma and a space, ", ".
Usage
Text.Combine({"Seattle", "WA"}, ", ")
Output
"Seattle, WA"