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".

Text.Combine({"Seattle", "WA"})

"SeattleWA"

Example 2

Combine text values "Seattle" and "WA" separated by a comma and a space, ", ".

Text.Combine({"Seattle", "WA"}, ", ")

"Seattle, WA"