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

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