Use the CLEAN () function to remove non-printable characters in Excel The CLEAN () function in Excel removes all non-printable characters from a given text string. It is the easiest and the most ...