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

6 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 01, 2020

    christian2100 

    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

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

      SergeiBaklan 

       

      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

    • 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

Resources