Excel Function : CLEAN

Download now!

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.