I have the following situation

Cell A

Abdal-Ghaffar, NadyN14264504Middle Eastern and Islamic StudiesPHD

Cell B

Abdal-Ghaffar, Nady

how do i build a formula on cell Cell C to look up the name on the text
string