The Hive - Learn, Help, Connect

Data Cleaning Bootcamp - in Excel, Python and R

Chapter 2 - Removing Unwanted Spaces

Lesson 4 - A Question!

Do you know the difference between the Excel formulae TRIM and CLEAN?


Do you know when to use each of them?


Did you know that you can combine TRIM, CLEAN and SUBSTITUTE in a single equation to take days, even weeks, off your data cleaning?


Tell me in the comments below (or in the forum) your experiences with using these formulae - whether good or bad!

In the next lesson we'll be going through these formulae so that you gain a really good understanding of them and know how to use them to super-charge your data cleaning efforts.

Love it or Hate it scaled
Do NOT follow this link or you will be banned from the site!