Copy data from three cells into one divided by line break
Posted on 2011-03-17
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.