My data looks bit like this
Joe Bloggs Joe Bloggs Family Business
Joe Bloggs Joe Bloggs Farm
John Smith John Smith Removals
Smith & Son Smith & Son Grocers
Jones Jones The Butchers
Jones, Smith & Bloggs Jones, Smith & Bloggs Solicitors
I would like a query (preferably) or a function to remove the contents of Field1 from Field2 and Trim the results i.e.