How To Remove Non Printable Characters In Excel
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.