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.

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.

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

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

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.

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.

"ice" wrote:

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

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