How to remove non printable characters in Excel?

In this lesson you can learn how to remove non printable characters in Excel with clean function.


It may happen that data copied from external websites will paste with non printable characters. This lesson lets you to clean up your spreadsheet. You can't print such a characters. It looks really unprofessionally.

To remove non printable characters use CLEAN function. Syntax is:


You remove non printable characters you can also use address of cell. Syntax in that condition is:

=CLEAN(A1) for a single cell


=CLEAN(A1:B10) for whole range of cells