I need title, first name and surname extracted from a list of names

This is a simple task. I've attached a list of contacts. In column F is a list of their names. I just need you to create a column of Title, First Name, Surname from this list. For example if the Name was below then I'd need the following title, firstname and surname. You are only completing the yellow cells. I don't want any of the other columns amended or removed as they all need to be used together later.

Name Title First name Surname

Dr Yuchen Zhao Dr Yuchen Zhao
Becker, Adib Adib Becker
Pusa, Dr Petteri Dr Petteri Pusa
Prof. Adi Armoni Professor Adi Armoni
Adlard, Dr Amy Dr Amy Adlard

You can refer to their email address to determine what is the correct surname etc.