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