How to Merge cells in Microsoft Excel?
There are different methods we can merge cells in Excel.
One of the most used methods is utilizing the Merge & Center option in the Home tab.
The issue with using Merge & Center is that it can combine the cells, but not the text within these cells. Let us say we have a data set, as shown below:
If we select cell A1 and B1 and use the Merge & Center option, it will keep the text from the leftmost cell (A1 in this case) and delete the text from all other cells.
Excel is not utterly ruthless, though it warns you before this happens. If you try and merge cells that have text in it, it shows a warning pop-up letting you know of this (as shown below).
If we go ahead and click OK, it will combine the two cells and keep the text from the leftmost cell only. In the above example, it will combine A1 and B1 and will show the Employee Name only.