MS Excel 2000 won't find and replace for character ~

[thEnEuRoMancER]

Any ideas why?

 

[kranky]

The tilde is used to flag Excel not to treat the following character as a special (wildcard) character. Normally it's used before an asterisk or ? to indicate to search for the next character literally, not as a wildcard character.

If you use two tildes in a row, does that work?

 

[thEnEuRoMancER]

Actually two tildes in a row works OK! Tnx a lot, I'll remember this one. I solved my problem then by copying to Word, replacing in Word and copying back to Excel.