Copy data from three cells into one divided by line break

Hi,

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.

For example
A1: 1
B1: 2
C1: 3
should be shown as
1
2
3
inside the cell D1

I tried the formula =A1 & CHAR(10) & B1 & CHAR(10) & C1 but that didnt do the trick.
Any suggestions?
nebb-sbtAsked:
Who is Participating?
 
jimyXConnect With a Mentor Commented:
You have to format the cell to wrap text first.
0
 
jimyXCommented:
For cell D1 right click then go to Alignment tab -> Text Control make sure to select Wrap text.
0
 
nebb-sbtAuthor Commented:
doh, thanks :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.