Putting two links and a text string into a cell?

Question

I would like a cell like this:

Change

20:25

to

20:30

where the two different times (20:25, 20:30) are sourced from two different cells. I would like to preserve the line breaks.

How might I achieve this?

Answer 1

Assuming the layout as in the image, please try:

=A1 & CHAR(10) & B1 &CHAR(10) & C1 & CHAR(10) &D1 

Alternatively:

="Change" & CHAR(10) & B1 & CHAR(10) & "to" & CHAR(10) & D1