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
Bookmarks