Text.Combine

This function returns a single text value that is a combination of the list of text values provided. Null values in the list are not included in the final result. Optionally, a separator can be specif...

Syntax

Text.Combine(texts as list, optional separator as nullable text) as text

About

This function returns a single text value that is a combination of the list of text values provided. Null values in the list are not included in the final result. Optionally, a separator can be specified to separate the combined text values.

Explanation

Example 1: Consolidate the text values "Seattle" and "WA" using Power Query M function Text.Combine. The output will be "SeattleWA". Example 2: Merge the text values "Seattle" and "WA" with a comma and space in between using Power Query M function Text.Combine. The output will be "Seattle, WA". Example 3: Combine the values "Seattle", null, and "WA" with a comma and space in between, ignoring the null value. Use Power Query M function Text.Combine. The output will be "Seattle, WA".