Power query editor - Adding text and columns in one step

[skopcak]

I need to add a new column to merge

In Excel would be a formula

= CONCATENATE ("Example:"; A2)

Result:

Data 1	Result 1
Text1	Example: Text1
Text2	Example: Text2
Text3	Example: Text3

How to describe the formula in the power query editor?

thank you answer

[Greg_Deckler · Accepted solution]

= [Column1] & [Column2]

[ImkeF · Accepted solution]

You need to escape the text like in Excel like this:

"Example"&[Data 1]

[v-chuncz-msft · Accepted solution]

@skopcak,

You could also use Text.Insert.

Text.Insert([Data 1], 0, "Example: ")

[ImkeF · Accepted solution]

You need to escape the text like in Excel like this:

"Example"&[Data 1]

[Greg_Deckler · Accepted solution]

= [Column1] & [Column2]