THANKS! That formula did exactly what I needed it to do!

"Gary''s Student" wrote:

Use:

=A1 & CHAR(10) & A2 & CHAR(10) & A3

and then format the cell as alignment wrap.
--
Gary's Student


"candy_k99" wrote:

I would like to combine 3 cells into 1, but I need to keep the formatting
intact. For example,
A1 = Cat
A2 = Dog
A3 = Bird

I need to display the information in a new cell in this way:
Cat
Dog
Bird

I can use the concatenate feature, but it runs it together. Do I need to
add a "return" in the formula and, if so, how do I do that?

Thanks for your assistance.