typing non printable characters

[lezawang]

Hi
I want to learn how to clean excel file from all none wanted characters. So I want to type these characters first and then learn how to use formulas etc to remove them. I want to know how to type these none printable characters in excel. I read the article below, it says that char(127) but what is that? I tried =char(127) but excel return empty cell.

I am interest to know how to type these none printable characters. specially [][] like in the article below. Thank you so much


https://www.lifewire.com/remove-non-printable-characters-3123798

 

[lezawang]

Re: typing none printable characters

Just want to add something. I just watched the video below and it says that if I type

=char(9) & "Fix this text"

Then I will get a none printable character before "fix this text". I did that and nothing was typed in front of "fix this text". Why is that? thank you.

https://www.youtube.com/watch?v=jw_XHSaZHmA

 

[RoryA]

Re: typing none printable characters

Most non printable characters are by their nature not displayed.

 

[lezawang]

Re: typing none printable characters

Thank you very much for your reply. But just curious, how they manage to type it here

https://www.lifewire.com/remove-non-printable-characters-3123798

Thanks once again

 

[RoryA]

Re: typing none printable characters

I said most, not all. Look at A3 in that example - there are 5 non-printing characters that you cannot see.

 

[Scott Huish]

Re: typing none printable characters

Hold down the Alt Key and a 4 digit code on the keypad.
For character 129
ALT-0129
Note that those numbers must be typed on the keypad not on the numbers at the top of the keyboard
�