Example:

A1 = TH Ewing B1 = Ewing
A2 = G Turner B2 = Turner
A3 = CIW Eastwood B3 = Eastwood


Col A contains peoples names using initials
Col B contains a formula that will return only the surname

I have tried MID and RIGHT in the formula but none seems suitable, anyone
got a solution?

Thanks
Pat