Merging cells in Excel can make your ... Merged cells can also make the spreadsheet look inconsistent or cause problems when importing and exporting data. To split the cells, start by selecting ...

Select the ‘Column data format’ or use what Excel chose for you. Finally, specify the ‘Destination’ where you would like the split data to appear on your worksheet. When done, hit ...