I want to copy text from three cells (e.g A1, B1 and C1) into D1.
Each text string should be divided by line break.
should be shown as
inside the cell D1
I tried the formula =A1 & CHAR(10) & B1 & CHAR(10) & C1 but that didnt do the trick.