Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

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

Excel can throw up various Data type Refresh errors. This post explains each and shows how to fix COULDN'T REFRESH DATA TYPES errors.