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:
=CLEAN(text)
You remove non printable characters you can also use address of cell.
Syntax in that condition is:
=CLEAN(A1) for a single cell
or
=CLEAN(A1:B10) for whole range of cells
After that you will be able to print as expected.
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References
