Excel Function : CLEAN
Removes all nonprintable characters from text
Microsoft Excel Reference Page
Syntax and Description of the CLEAN Excel Function
syntax This is the syntax of the Excel CLEAN function: =CLEAN(text) Where text is the text string that you want to clean. The CLEAN function will remove all non-printable characters from the text string.
About CLEAN Excel Function
CLEAN(text) The CLEAN function removes all non-printable characters from a string. Non-printable characters are typically not visible when viewing a text string in a worksheet.