Certain information sources export all their data into a single column, when ideally you would want it split into separate columns. The Text to Column tool allows for this but it also has some other useful tools for cleaning data. It is invaluable as a data clean-up tool. As the name implies it takes text that is in a single column and splits it over many columns based on some delimiter (the item that tells us where the split is e.g. a comma).
To see the full course contents click here.