Using Built-In Excel Functions Another way to split data into multiple columns is to use some of Microsoft Excel's functions.

How to Split Merged Cells in Excel Sometimes, merged cells can interfere with some of Excel’s important features.