Learn how to use the Excel CLEAN function with syntax and examples.
The Microsoft Excel CLEAN function removes all nonprintable characters from a string.
The syntax for the Microsoft Excel CLEAN function is:
CLEAN( text )
text is the value that has all nonprintable characters removed from.
The CLEAN function can be used in the following versions of Microsoft Excel:
The CLEAN function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel CLEAN function examples and explore how to use the CLEAN function as a worksheet function in Microsoft Excel:
Based on the spreadsheet above, the following Excel CLEAN examples would return:
=CLEAN(A1) Result: "hi there" =CLEAN(A2) Result: "this is a test"