Convert Text to Columns

If you've worked with Excel, chances are that you've seen data in pretty bad shape. You know, data all together with missing elements, etc. See graphic below.

Here the data is all in one cell. You can't really work with this data. You need to segregate this data into its separate elements. It looks like there are some numbers, a region, a last name, a product, a quantity, a price and a total.

To solve this problem, we use the cool Text to Columns feature in Excel. The good news is that it's easy to use. The bad news is that most of the time you need to tweak it just a little to complete the transformation.

Here, I created a quick video on how to do just that. Oh and the sample data is here