Thankfully, Excel makes merging and splitting cells ... or cause problems when importing and exporting data. To split the cells, start by selecting the merged cells on the sheet.