I'm looking for a result of "Mrs." and "Dr." respectively in my example above.

Because I don't know any better, I've sorted the column (by color) so that this function will apply only to those cells where the pattern PREFIX1_NAME1_AND_PREFIX2_NAME2 applies.

In other words, I want PREFIX2. In general I'm looking for formulas for all of the above, but right now I'm having trouble getting PREFIX2 in particular.

Thank you!