Thanks, I haven't had a chance to check that out just yet. Unfortunately, they have just thrown yet another monkey wrench into the deal.

I now have an optional couple of words which will appear AFTER the parentheses, and although I know what the 2 words will be, I don't know what will be following, so I cannot use what worked above by looking for characters that are not '(' or ')'.

So, now I'm looking for the following:

'BRAND® XXL (sub brand text) EXACT TEXT' continued sentence text...

Where both 'XXL' and 'EXACT TEXT' are variable (and will always be used together; either they are both included or both excluded).

It looks like i may very likely need to use Regular Expressions, which I have used once or twice before in VBA, but for parsing text in variables, not in a word document find/replace. My biggest concern is how reliably can I know/assume that the vbscript Regular Expressions library that I am using is installed on the user's system? Is this installed with the Windows OS, and is it something that their IT could have omitted from their install?



There's also another wrinkle to the problem that I just found out about, in that the first mention of each version on each page needs to be the full text. I don't believe that should be a problem as I can check each found set, and keep track of whether that version has been shortened for each page. Edit: I got this part working properly, so this is no longer an issue.