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 ...

Learn how to parse data in Microsoft Excel easily using our step-by-step guide.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.