Data cleanup in Excel

Split Columns with Formula to create a cleanup template

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

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.

0 of 45 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop