Merging content of 2 cells to one cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1501379%22%20slang%3D%22en-US%22%3EMerging%20content%20of%202%20cells%20to%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1501379%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22christian2100_0-1593612004288.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202600i8417A37D19A84517%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22christian2100_0-1593612004288.png%22%20alt%3D%22christian2100_0-1593612004288.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI%20need%20some%20help.%3C%2FP%3E%3CP%3EHope%20someone%20can%20help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ekind%20regards%20Christian%2C%20Denmark%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1501379%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1501455%22%20slang%3D%22en-US%22%3ERe%3A%20Merging%20content%20of%202%20cells%20to%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1501455%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F715548%22%20target%3D%22_blank%22%3E%40christian2100%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20579px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202605i166C1A4BFDB2F1C6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ewith%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DINDEX(A%3AA%2CROW()*2-1)%26amp%3BCHAR(10)%26amp%3BINDEX(A%3AA%2CROW()*2)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDon't%20forget%20to%20apply%20%3CSTRONG%3EWrap%20text%3C%2FSTRONG%3E%20to%20resulting%20cells%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

christian2100_0-1593612004288.png

 

Hi all,

I need some help.

Hope someone can help?

 

kind regards Christian, Denmark

 

 

6 Replies
Highlighted

@christian2100 

That could be

image.png

with

 

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

 

Don't forget to apply Wrap text to resulting cells

Highlighted

@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?

christian2100_0-1593671154858.png

Br Christian

 

 

Highlighted

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

Highlighted

@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

Highlighted

@Mourad Louha 

 

Thanks so much, you solved the problem.

Br Christian

Highlighted

@christian2100 

Christian, glad to help.

@Mourad Louha , thank you