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

Copying the formula from the formula bar at the top of the Google Sheets window and pasting it into another cell duplicates the formula exactly as it is. In other words, the references won't change ...