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

Formulas and Functions

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

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
- SergeiBaklan
  Diamond Contributor
  Jul 02, 2020
  christian2100
  
  Christian, glad to help.
  
  Mourad-Louha , thank you
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
  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
    Copper Contributor
    Jul 02, 2020
    Mourad-Louha
    
    Thanks so much, you solved the problem.
    Br Christian

Resources