Use the CLEAN Text function to remove all nonprintable characters - Text Functions - Microsoft Excel Tutorials

Use the CLEAN Text function to remove all nonprintable characters in 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->.

Watch the Video Tutorial - https://www.youtube.com/watch?v=bJy1Vuuzqyg