=MID(A1,FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))))+1,255)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"zomex" wrote in message
...
if the names given are
peter alan smith
geroge w bush
william scott scotty

than how can i retrive the last name, in another cell... like for the
retreval of first name the formula =LEFT(E5, FIND(" ",E5)) would do the
trick, but cant seem to figure how to retreve the last name...
thanks