View Single Post
 
Old 09-17-2021, 09:47 AM
rekent rekent is offline Windows 10 Office 2016
Novice
 
Join Date: May 2014
Posts: 23
rekent is on a distinguished road
Default VBA wildcard search that only identifies results that do not follow delineated words

I am adding a routine to some VBA code to search for instances of a period that is followed by one space and then [0-9A-z] to identify the start of a new sentence. This is being done to identify instances of one space rather than two between sentences.

However, there are some obvious cases such as abbreviations mid-sentence that require periods, Mrs./Mr./etc. and others that will flag using the wildcard search for the above terms but should not have a double space following the period.

Is it possible to condition a wildcard search to only return results if it does not follow a word found on a delineated list of words?
Reply With Quote