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.

Highlight the cells that you want to split On the Data tab ... Text to columns wizard is to separate the content of one excel cell into separate cells. You can set the delimiters that your ...