How to Use CLEAN Function

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

Formula:

= CLEAN (text)

Explanations:

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

Cautions:

– 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.

= CLEAN(C6)

You will find nonprintable characters are removed.

Download: Clean Function

Leave a Reply