Wildcard Find/Replace deletes extra character
I'm trying to do a Find/Replace with a wildcard to find text which doesn't have a certain character (in this case a circle-R) following it. This will eventually be done through a VBA script, but I am having issues doing it manually as well.
The search string I am using is "XXXXXXX[!®]", and the replacement string is "XXXXXXX®". The problem I am having is that it is replacing the next character after the search string (usually either a space or a period), so that if it found "XXXXXXX is a..." I get "XXXXXXX®is a..." and "XXXXXXX. The..." becomes XXXXXXX® The..."
|