USE THE CLEAN TEXT FUNCTION TO REMOVE ALL NONPRINTABLE CHARACTERS USING MICROSOFT EXCEL

If data is imported from other applications, it is possible for this data to contain characters that may not be printable. In this case, the CLEAN text function of Microsoft Excel can be used to remove all nonprintable characters from text. 

To delete nonprintable characters:

1. Type any text in cells A2:A5. Make sure that some of the cells contain nonprintable characters.
2. Select cells A2:A5 and type the following formula: =CLEAN(A2).
3. Press <-Ctrl+Enter->.

USE THE CLEAN TEXT FUNCTION TO REMOVE ALL NONPRINTABLE CHARACTERS USING MICROSOFT EXCEL