Forum Discussion

Copper Contributor

Jul 01, 2020

Merging content of 2 cells to one cell

Hi all, I need some help. Hope someone can help? kind regards Christian, Denmark

Diamond Contributor

Jul 01, 2020

That could be

with

=INDEX(A:A,ROW()*2-1)&CHAR(10)&INDEX(A:A,ROW()*2)

Don't forget to apply Wrap text to resulting cells

Copper Contributor

Jul 02, 2020

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