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.