Combine data from several cells to one cell

[Hossainexcel]

Hi Friends,
Would anyone help me out to put all combined data in one cell breaking into several line?

For example: Say cell A5 & B6 data needs to combine in cell C6, whereas in the cell C6 data should be shown one(B6) under other (A5).

Note : Fomula "=(A5&B6)" gives result in single line.

Thanks in advance

[Phuocam]

Try this ...

=A5&CHAR(10)&B6

Format Cells -> Alignment -> Wraptext

[Hossainexcel]

Awesome!
It's work. Thanks lots Mr. Phuocam.

[Phuocam]

You're welcome.