To merge cells in Excel, select all the cells you want to merge ... or cause problems when importing and exporting data. To split the cells, start by selecting the merged cells on the sheet.

This formula allows you to split text into multiple columns ... With methods such as Text to Columns, Flash Fill, and Excel formulas, you can select the approach that best suits your needs.