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.

Learn MS Excel


Ask Questions

Ask Question