Remove non printable character in Excel

For example, when importing files from a database or external sources, there could be non printable characters as part of import, how can I remove them?

To do it in Excel, here is the answer:

a) Enter the formula =CLEAN(AJ2) as shown below where AJ2 corresponds to the cell that needs to be cleaned containing the non-printable characters.

excel remove non printable character

 

You can find similar Excel Questions and Answer hereunder

1) How can I get the last non-zero value in a row?

2) How do I have proper (Capitalize the first letter in each word of a text) text in cells ?

3) How can I remove display of Gridlines in my worksheet using VBA?

4) I have to enter non alphanumeric characters in a cell using VBA - how can I get their codes for use in VBA?

5) Find and count instances of a character in a string in Excel

6) Remove the apostrophe cell text values in Excel

7) Can I determine the number of times a character appears in a cell using formula?

8) How can I remove hyperlinks from a range of cells?

9) How can I set non-contiguous print area using VBA?

10) How can I quickly remove all blank cells in a data range?

 

Here the previous and next chapter