Excel Function : CLEAN
Category
Text
Description
Removes all nonprintable characters from text
Microsoft Excel Reference Page
https://support.office.com/en-us/article/CLEAN-function-26f3d7c5-475f-4a9c-90e5-4b8ba987ba41
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.