Formula

  • Thread starter Thread starter Cazumel
  • Start date Start date
C

Cazumel

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
 
Hi Thank you so much for your help , I am still stcuk a bit I do not want to
separete the name but to look up in another cell

Cell A =A bdal-Ghaffar, NadyN14264504Middle Eastern and Islamic StudiesPHD

Cell B = Abdal-Ghaffar, Nady

Cell C = look up B in A and return to C

Thank you
 
Back
Top