multiple rows in a cell

[ansmanian]

I have to combine data from different cells into one cell with seperate line for each data.
I have data in each cell as ABCD EFGH IJKL MNOP and i require the output in one cell as
ABCD
EFGH
IJKL
MNOP

Is there any formula to do this? I tried using concatenate formula but i could not get the result in seperate lines.
Thanks.

[Jakobshavn]

=a1 & char(10) & b1 & char(10) & c1 & char(10) & d1

[martindwilson]

=A1&CHAR(10)&B1&CHAR(10)&C1&CHAR(10)&D1 format cell to wrap text

[ansmanian]

Thanks. It is not working. Can you please explain in detail.

[ansmanian]

Excellent. It worked. thanks a lot.