Introduction to splitting text into columns

Introduction to splitting text into columns

This module of the Data Cleanup Course will show you the various techniques, using tools and/ or formula, to split text into different columns.

So whether it is nice and straight forward like the left hand example below, or more complex like the right hand example, we show tools and formula that can handle both these options.

introduction-to-text-to-columns

With limited effort, the above should look like this, nicely seperated into its own columns for further work.

introduction-to-text-to-columns

We also show the more advanced ways where your text has variable number of columns in each item of text . So in the example below, how to extract only the last part of the path even though the number of ‘\’ vary per line.

introduction-to-text-to-columns

The end result should look like this and it will create a reusable template with little effort from yourself.

introduction-to-text-to-columns

Back to: Data cleanup in Excel > Split columns in Excel