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.