Clean function in excel removes all non-printable characters from the text. This function is designed to remove all non-printable characters.
Syntax of the Clean function
CLEAN(text)
The ASCII code of the non-printable characters is 0 to 31. The following are the characters which are non-printable.
