View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zomex
 
Posts: n/a
Default HOW TO RETRIVE LAST NAME USING EXCEL, IT SHOULD BE GENERIC

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