To split the cells, start by selecting the merged cells on the sheet. Next, navigate to the Alignment group in the ribbon of the Home tab. Click the down arrow next to the Merge and Center button ...

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.