Find and replace problem

I deal with spreadsheets that contain people's names. (Property owners). Each cell can contain anywhere from 1 to 100 names, each separated by " & ".
Eg: "Joe Henry Smith & Mary Smith & Aloysius van der beek".
Through experience, i recognise that the last name is a lawyer, and not a true owner, so I need to delete him. Because it's quite likely he appears in many cells, I currently do a "Find '& Aloysius van der beek'" and "Replace with '" (ie a blank, effectively deleting him).
Because I'm dealing with tens of thousands of cells, (the "owner" file) this is quite time consuming as I have to look in each cell, find the odd one out, then copy and paste into the "Find and Replace" dialogue box.

What I want to do is find the odd one out as at present, but copy the name into another spreadsheet or workbook (the "lawyer" file). Then get Excel to go through the lawyer file and look for all the names there on the owner file, and replace them in the owner file with a blank.

This would also mean that I build up a list of lawyers that I could re-use with different owner files.
I guess I'm after a fancy variation of vlookup. Or some sort of macro.

Help!

Maybe Data - Text to Columns is something you could use.

Using the ampersand as the delimiter would place the names in different columns and that would easily place the lawyer in the last column of the split.