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