View My Drafts
In this blog post, we'll take a closer look at a custom function for text cleaning that I created for our ongoing series at Enterprise DNA TV called Problem of the Week.
For week #2, we have a messy data that needs to be cleaned up. Our goal here is to clean up all the text values in both columns. You may watch the full video of this tutorial at the bottom of this blog.
For this task, I created a clean text function.