Forum Discussion
christian2100
Jul 01, 2020Copper Contributor
Merging content of 2 cells to one cell
Hi all, I need some help. Hope someone can help? kind regards Christian, Denmark
christian2100
Jul 02, 2020Copper Contributor
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
Mourad-Louha
Jul 02, 2020MVP
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)
=INDEKS(A:A;RÆKKE()*2-1)&TEGN(10)&INDEKS(A:A;RÆKKE()*2)
Best,
Mourad
- christian2100Jul 02, 2020Copper Contributor