Forum Discussion
Merging multiple excel cells
I have an excel table with a header that takes 3 cells, how can I merge or remove the cell lines for the 3 cells so that it all appears to be in a cell. like I don't want to see the cell lines in the header. see below and then also center it. Thank you
| Served by Contract and Zip Code* |
| Fiscal Year 2024 Quarter 4 Year-to-Date (June 1, 2024 - August 31, 2024) |
| For Internal Use Only |
1 Reply
This will require copy and pasting the contents into one cell.
Alternatively, you can use a formula.
Let's say that the three cells are B1:B3.
In another cell, enter the formula
=TEXTJOIN(CHAR(10), TRUE, TRIM(SUBSTITUTE(B1:B3, CHAR(160), " ")))
Turn on Wrap Text for the cell with the formula, set its horizontal alignment to Center, and make it wide enough to display the text you want.
