CLEAN Function
The CLEAN function is used to remove any non-printable characters from the given text.
Formula:
=CLEAN(Text)Whereas "Text" is the information which has to be cleaned.
Video Tutorial:
Let us remove non-prinable characters, using CLEAN function, with the help of the given video tutorial.