Text.Combine Function in Power Query
The Text.Combine function returns a text value that is the result of joining the list of text values, into a single text value. We can use an optional separator, which is used to separate the text values while joining.
Syntax
Text.Combine(texts as list, optional separator as nullable text) as text
Example: Combine text values.
Power Query M
= Text.Combine({"Ashish", "Goel"}) The output will be "AshishGoel".
Example: Combine text values and separate them with a space.
Power Query M
= Text.Combine({"Ashish", "Goel"}, " ") The output will be “Ashish Goel”.
