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)