Merging content of 2 cells to one cell

New Contributor



Hi all,

I need some help.

Hope someone can help?


kind regards Christian, Denmark



6 Replies


That could be






Don't forget to apply Wrap text to resulting cells

@Sergei Baklan 


Hi Sergei 


Thanks for your answer.

I dont know what I am doing wrong I am pasting the formular in fx line.

But i doesn´t work for me?


Br Christian



Hi @christian2100,

it looks like your Excel is in Danish. If yes, then you should translate the formula to danish - what implies on one hand the translation of the function names and on another hand the use of the list separator of your system (usually ; instead of a comma)






@Sergei Baklan 


Hi Sergei


Thanks so much for your help.

Much appreciated.

It now works when I got the formula translated into Danish.


Br Christian,Copenhagen Denmark

@Mourad Louha 


Thanks so much, you solved the problem.

Br Christian


Christian, glad to help.

@Mourad Louha , thank you