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. Any null
values present in texts
are ignored. An optional separator
used in the final combined text can be specified.
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"
Example 3
Combine the values "Seattle", null
, and "WA", separated by a comma and a space. (Note that the null
is ignored.)
Usage
Text.Combine({"Seattle", null, "WA"}, ", ")
Output
"Seattle, WA"
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for