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

After that you will be able to print as expected.


You can download the Template here – Download
Previous articleHow To Link Objects In Excel
Next articleGoogle Classroom Tutorial