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 linked to the original values, meaning ...

All that’s left to do is to save the modified data to Microsoft Excel, as follows: 5. Click the Home tab. 6. In the Close group, click Close and Load from the Close & Load dropdown.

How to create data bars in Excel. 1. Select the cells you want to apply the data bars to. You can select a single cell, a range of cells, a table, or the entire sheet. 2.