Combine Cells
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. |
Combine Cells
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. |
Combine Cells
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. |
Combine Cells
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. |
Combine Cells
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. |
All times are GMT +1. The time now is 02:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com