Combine Cells

C

candy_k99

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.
 
G

Gary''s Student

Use:

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

and then format the cell as alignment wrap.
 
I

ice

if i understand rihgt you want the information from the three cells to one
but with space between.

Try concatenate as you did but after the cell selection, add a space, a
comma or whatever you need to have.

Hope it helps
 
C

candy_k99

Thanks, "ice" for your assistance. I needed the info to "stack" in the cell
and needed to use the char(10) (return) to make it work.
 
Top