Can anyone help. I want extract the first name and surname from a text string containing their full name.

e.g. HAWES:GEORGE RICHARD becomes HAWES:GEORGE

Obviously they are all different lengths of name

Many thanks

Jack