Possible to add a Line break in a formula ?

[Ricardo the Numpty]

I have 4 cells of postal address data which I want to combine and include
line breaks.

I know that to combine them in a continuous sequence I can use

=B4&", "&C4&", "&D4&", "&E4

But I want to insert a line break instead of a comma so that the result
appears as follows

B4
C4
D4
E4

instead of B4, C4, D4, E4 which the previous formula would give me.

Anyone any ideas?

 

[Gary''s Student]

=b4 & char(10) & c4 & char(10) & d4 & char(10) & e4

Then:
Format > Cells... > Alignment > check wrap on

 

[Ricardo the Numpty]

Have a big gold star

Many thanks.

=b4 & char(10) & c4 & char(10) & d4 & char(10) & e4

Then:
Format > Cells... > Alignment > check wrap on