Combining Row Data into single cell

[dberg30]

Hi there. I am looking for a formula that will combine data in multiple cells in a row into 1 cell, but split via linebreaks. Has anyone been able to take this on?
I don't suppose I can add a screen shot, but this is what I am looking for:

        A          B          C          D
1  Data 1      Data 1     Data 2     Data 3
   Data 2
   Data 3
2
3
4
5
6

Essentially it's combining values of B1, C1, and D1 to cell A1.

 

[meldoc]

Hello

try, and wrap text.

=B1&CHAR(10)&C1&CHAR(10)&D1

 

[dberg30]

cool, seemed to work. I'm assuming Character 10 refers to the enter key?

 

[meldoc]

Yes-ish it's actually Line Feed.

http://www.robelle.com/smugbook/ascii.html