ctrl+H does not find/replace special char

[lezawang]

Hi I have some cells which have ~ and I want to remove that char from them, for example I have a cell which is

=CHAR(126)&"Hello"&CHAR(126)

I selected these cells and then Ctrl+H and then ALT+0126 then click find. Excel could not find any. Excel stayed in the first cell in the range. I followed these steps from MS forum. Thank you.


https://answers.microsoft.com/en-us...lls/608fbbb9-8ac4-482a-90b4-8bf818c28f71?db=5

[FONT=&quot]The excel understandable code for your specialcharacter is 225, which you can also see by the formula =code(a1) wherein A1contains your special character.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]To get rid of this, Either Select whole sheet, orselect only 1 cell. go to CTRL+H, go to find box, click back spaceso that you ensure there is nothing in that and then type 0225 while pressingALT. (But this 0225 should be typed through numeric key pad. In case of yourlaptop, this you can activate through pressing Fn and NmLk Key. This isavailable on the typing character M,J,K,L,U,I,O like that simultaneously.[/FONT]
[FONT=&quot]So when you type this in Find box, then it will showthe same character there,[/FONT]
[FONT=&quot]Keep Blank replace Box.[/FONT]
[FONT=&quot]Then Press Replace All.[/FONT]

 

[sandy666]

try:
Find: ~~

 

[lezawang]

Thanks, it did work if i have

~ Hello ~

but could not find

~Hello~

the first case, has space between ~ and H the second one no space.

 

[MARK858]

In the Find what

~~Hello~~