Extract Names in Excel

For last name with just first and last name - John Smith
=RIGHT(c2,LEN(c2)-FIND(" ",c2))

For the last name word regardless - John and Susan Smith
=RIGHT(c2,LEN(c2)-FIND("*",SUBSTITUTE(c2," ","*",LEN(c2)-LEN(SUBSTITUTE(c2," ","")))))

For the first name once you have last name
=LEFT(C2,LEN(C2)-LEN(D2)-1)