With the functions I'll discuss here, you can make data cleanup much easier in Excel. They allow you to extract, style, split, and join text to get what you need without wasting hours doing it ...

Note that the license agreement explicitely states you're responsible for the use of this module. I, in particular, cannot be held responsible for any cost incurred due to the use or mis-use of this ...