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

Formatting your data as a table using Excel's Format As Table function will cause filter buttons to appear automatically. There may be occasions when you want to split data into two or more cells ...