=CONCATENATE(A1,CHAR(10),A2,CHAR(10),A3,CHAR(10),A 4)
or
=A1 & CHAR(10) & A2 & CHAR(10) & A3 & CHAR(10) & A4

Make sure the cell is formatted to wrap text.

"Bretter99" wrote:

For example: =concatenate(a1,a2,a3,a4) = ILIKEBEEFBURGERS, But I want it to
put the result into a single excel cell like this:
I
LIKE
BEEF
BURGERS

But i cant see how to manually insert a line break into my statement as in
something like:
=concatenate(a1,<line break,a2,<line break,a3,<line break,a4,<line break,)
Any suggestions would be appreciated, thanks :P