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.

To separate first and last names using delimiters: Excel will split the first and last names into two columns. You can also use this to separate first, middle, and last names. Another easy way to ...

The TEXTSPLIT function will split the email at the ‘@’ character and return the name and the domain in cells B2 and C2 respectively. The Text to Columns feature in Excel allows you to split ...