=TRIM(RIGHT(SUBSTITUTE(TRIM(A1)," ",REPT(" ",99)),99))
=TRIM(SUBSTITUTE(A1,C1,""))
=LEFT(A2,FIND(",",A2 & ",")-1)
=TRIM(MID(A2,FIND(",",A2 & ",")+1,99))
If your full name data are already in the format Last Name, First Name, your problem gets much simpler.No, mostly are "FirstName LastName", however those that have a comma are "LastName, FirstName".
=right(A1, find(" ", A1)+1