Split Columns with Formula to create a cleanup template

Please sign up for the course before starting the lesson.

If you want to create a template that you can reuse every month, then it is better to spend the extra time creating formula that will do the work for you.

The first functions to learn are the LEFT, RIGHT and MID functions which allow you to extract a set number of characters from the LEFT of the cell, the RIGHT of the cell or the MIDdle of the cell. For the more complex situations you may need to use the formulas shown lower down.

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