How do merge two cells with a carriage return in between the two v

[Richard]

Hi,
I'm pretty new to excel and having trouble merging the contents of two
cells. What I want to do is automatically merge two cells into one with a
carriage return (ALT+ENTER) between each cell value. Is this possible? Please
advise.

Thank You

 

[Dave Peterson]

Like with a formula?

=a1&char(10)&b1

Format|Cells|alignment tab|make sure wrap text is enabled.

 

[Richard]

That's it! How do I get it go throught the entire list and do this
automatically?

 

[Dave Peterson]

Depends on what you mean...

If your columns to concatenate are A and B, you could create that single formula
in C1 and then drag down the column as far as you need.

Then format column C to apply wrap text.

Debra Dalgleish has some instructions with pictures:
http://www.contextures.com/xlDataEntry01.html

 

[Richard]

I do need to be led by the hand. I don't even know what "Concatenate" means?
I'll check out the website. Thanks for your assistance.

 

[Dave Peterson]

http://dictionary.reference.com/search?q=concatenate

To join stuff together.