How to Split Columns in Excel
Sometimes, you'll find yourself working with data that needs to be split. The data looks like it's in a column, but is hard-coded to a single column.
This is where text to columns comes into play. If there's a common character between each column, like "|" in the GIF example, you can use the text-to-columns function to split it up easily.