Video Merge Cells Or Split Merged Data. Right click any merged cell and select the Delete from the right-clicking menu. Merge cells or split merged data.
When the two cells are merged only the data contained in the top left one is retained. Click in a cell or select multiple cells that you want to split. Right click any merged cell and select the Delete from the right-clicking menu.
And then select the range again.
Merging cells in Excel is easy. Under Table Tools on the Layout tab in the Merge group click Split Cells. Enter the number of columns or rows that you want to split the selected cells. You can Select all merged cells by selecting one merged cell in the Find and Replace dialog box and then pressing the Ctrl A keys simultaneously.