"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

You could always use alt+enter - it just starts a new line within a cell.