Change header in PQ issue if space in name

Hi

i do have different data source with different language headers. Currently I am running into an issue in exchanging the header by using this formula

HTML Code: 

Issue is that I do have one header named "Target" and one header called "Target per day", also one for "Day".

So they exchanged header with my formula create something like "Target pro Day" as Target and Day is found as single words. I thought the formula take the whole cell content and translate this.

Is it possible to change the formula to achive the whole translation?

Hi

this looks good, Thanks a lot. I will copy the formula to a bigger file with more tables and more columns. Hope this will be fine there as well.

Let you know

thanks