You could use Data TextToColumns using "space" as the delimiter, and
either break the names out into two columns, or choose not to import the
initials and only preserve the last names in column A

Vaya con Dios,
Chuck, CABGx3


"Pat" wrote in message
...
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