Using Built-In Excel Functions Another way to split data into multiple columns is to use some of Microsoft Excel's functions. If you choose this route, remember that the split values will be ...

Select the columns you want to fix. In this case we’re selecting the header columns — those at the very top of the ...

Click and drag your mouse across the two original column headers, right-click the selection and select "Delete" to remove the columns without affecting the data in the consolidated column.

You can change views in Excel depending on what you're doing and what you want to see. Learn how in this step-by-step tutorial.

Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.