Find and Replace

[M]

Why doesn’t Find and Replace work with this character ~

I literally can’t remove it other than by manually entering every cell.

[administrator@dailyexcel.net]

That’s a tilde ~ character.

To replace a tilde (or a wildcard character, a question mark ? and asterisk *) you will have to use another tilde to tell Excel you aren’t trying to use wildcard characters in Find and Replace.

Type

~~ in order to replace ~

~? in order to replace ?

~~ in order to replace ~

Br,

• This reply was modified 1 week, 5 days ago by administrator@dailyexcel.net.

[Author]

Posts