Thread: HOW TO RETRIVE LAST NAME USING EXCEL, IT SHOULD BE GENERIC
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default HOW TO RETRIVE LAST NAME USING EXCEL, IT SHOULD BE GENERIC
=MID(E5, FIND(" ", E5, FIND(" ", E5)+1), LEN(E5)

HTH
Kostis Vezerides

Reply With QuoteReply With Quote