Spreadsheet Tips

How to Split Columns in Excel

October 19, 2018
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.