How to use the Excel CLEAN function

Clean Function in excel is a text function in excel which is used to clean the text with the characters which are not printed when we use the print option, this is also an inbuilt function in excel and to use this function type =CLEAN( in a cell and provide a text as an argument, remember it removes the non printable character.

Syntax: =CLEAN(text)

The CLEAN function syntax has the following arguments:

  • Text (required argument) –  The worksheet information from which we intend to remove non-printable characters.

Example: Let’s look at some Excel CLEAN function examples and explore how to use the CLEAN function as a worksheet function in Microsoft Excel:

Excel CLEAN function 1 - How to use the Excel CLEAN function

Syntax:  =CLEAN(A1)

Result:

Excel CLEAN function - How to use the Excel CLEAN function

=CLEAN(A2)
Result: “this is a test”

Add a Comment

Your email address will not be published. Required fields are marked *