How to Use CLEAN Function

The CLEAN function will remove all the nonprintable characters from the text.


= CLEAN (text)


– Text is required; the text that you need to remove nonprintable characters.


– The CLEAN function will remove the first 32 nonprinting characters from text. In the 7-bit ASCII code, they are from 0 to 31.

Example: To remove the extra characters in and after the text in column C.


You will find nonprintable characters are removed.

Download: Clean Function

Leave a Reply