View Single Post
 
Old 06-20-2014, 07:48 AM
Cosmo Cosmo is offline Windows Vista Office 2007
Competent Performer
 
Join Date: Mar 2012
Posts: 240
Cosmo is on a distinguished road
Default 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..."
Reply With Quote