In this blog post, I will show you an example of the “alternative uses” of Excel functions and formulae that will help you clean your text data.