Often in Excel, I'll have a long list of data in one column, that I really wish I had in two columns.
A great example would be two numbers with a space, or maybe a column of names like "Eric, Andrews".
Before I knew about the Text to Columns feature, I used to go through these lists manually to move the data into a second column.
But once I encountered a 1000 row list, I realized it just was not possible anymore to do this work manually.
So I found a way to split up data using Text to Columns in just a couple clicks.
And by the end of this post, so will you!