In the range A2:A5 I have the names:
Mike J Hunter
Norman-Price Smith
Harry. Redknapp
Prince-H, Hughes
My goal is to extract First, Middle and Last names to get this:
Mike -------------- J ----------- Hunter
Norman ----------- Price ------- Smith
Harry ------------- ------------ Redknapp...