Click the ribbon's "Home" tab. Click the merged cell you would like to split. Excel displays the "Merge & Center" button and highlights it. Click that button to split the cell back into its ...

To merge cells in Excel, select all the cells you want to merge—make sure they're adjacent. Then go to the Home tab, and click the Merge and Center button ... To split the cells, start by ...

You can split cells into columns in Excel using the "Text to Columns" tool. Excel gives you two ways to split cells into columns: using delimiters, or using a manual fixed width. Splitting cells ...