How To Merge Cells In Microsoft Excel And Google Sheets

We need to briefly cover what happens when you merge several cells in Excel or Google Sheets. Or, more specifically, what does not. The merge cells function is designed to combine the actual cells themselves, not their contents. While spreadsheet programs can be used to conduct mathematical operations if you know the formulas, merging cells is not a shortcut.

In the event you merge two cells that both have something in them, then only the contents of the leftmost cell will carry over into the resulting merged cell. Any other cells you merged will have their contents deleted. You can’t use cell merging to combine numbers or words — if you want a larger cell to share contents, you’ll need to copy and paste the contents of the component cells over to the lead cell before you merge them, or you’ll lose it all.

SOURCE