Power Query
published
Search
⌃K

Text.Combine

Text.Combine

Concatenates a list of text values into one text value.
function (texts as list, optional separator as nullable any) as text

Description

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.

Category

Text.Transformations

Examples

Combine text values "Seattle" and "WA".
Text.Combine({"Seattle", "WA"})
"SeattleWA"
Combine text values "Seattle" and "WA" separated by a comma and a space, ", ".
Text.Combine({"Seattle", "WA"}, ", ")
"Seattle, WA"