Forum Discussion

christian2100's avatar
christian2100
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    
excel
Formulas and Functions
christian2100's avatar
christian2100
Copper Contributor
Jul 02, 2020

SergeiBaklan 

 

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's avatar
Mourad-Louha
MVP
Jul 02, 2020

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

  • christian2100's avatar
    christian2100
    Copper Contributor
    Jul 02, 2020

    Mourad-Louha 

     

    Thanks so much, you solved the problem.

    Br Christian

Resources