CLEAN Excel function

How to use the CLEAN Excel function to remove the unprintable characters from a cell

Related-View our course on cleaning data with Excel

CLEAN Excel function

The clean excel function allows you to clean up cells in Excel which have characters that aren’t recognized. This typically happens when you import data from another system. You’ll see here, the word Excel here occasionally has got a character that Excel doesn’t recognize. This can cause problems with your other formulae – so to use the clean function,activate the function wizard, look for the function called clean – here you’ll see it says remove all non printable characters from text – all you have to do is point to where it is, click ok and now when we copy it down you’ll see all the non printable characters have been removed.