Hello and welcome to the forum,

As a general rule of thumb, you have to be able to set 'rules' to guide any formula or macro to run; they are not inherently intuitive. You can always set multiple rules in a hierarchical fashion so that for example:

1. the number comes between parentheses right after the term "Multiple Sclerosis"... if not then...
2. the number comes right after "Multiple Sclerosis"... if not then...
3. the number comes right after "MS"... etc.

If you can't dictate a logical sequence because the data will be completely random then the results will also be completely random.

Having said that, can you provide us with logical If then statements with before/ after examples.

Thanks.

abousetta