remove non printable character in Excel

Q33. In Excel, how can I remove all nonprintable characters from text?

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 turn off Alerts using VBA?

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

3) How can I set Page orientation, Zoom % , Title Rows and footer using VBA?

4) Is there a way to create an visually impactful report with stop lights indicating automatically if Target is met?

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

6) How can I enter multiple lines of data in a cell?

7) How can I prevent users from seeing / accessing my macro code?

8) How can I calculate values applying complex Engineering formulas using Excel?

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

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

11) In a Table , how can I remove duplicate records?

12) How can I sort data using multiple criteria?

13) How can I check if a file exists in a folder using VBA?

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

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