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.
With limited effort, the above should look like this, nicely seperated into its own columns for further work.
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.
The end result should look like this and it will create a reusable template with little effort from yourself.