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

Add Numbers in Excel Performing addition in Excel is fairly straightforward. You can either add numbers directly or use cell references to work with values stored in specific cells.