- This topic has 1 reply, 1 voice, and was last updated 1 week, 5 days ago by .
Viewing 1 reply thread
-
Posts
-
-
Why doesn’t Find and Replace work with this character ~
I literally can’t remove it other than by manually entering every cell.
-
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,
-
Viewing 1 reply thread