Thread: Find And Display Surname
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_518_] Rick Rothstein \(MVP - VB\)[_518_] is offline
external usenet poster
  
Posts: 1
Default Find And Display Surname
=MID(A1,MAX((MID(A1,ROW(1:255),1)=" ")*ROW(1:255))+1,255)

If you make the ROW references absolute, then you'll be able to copy the
formula by dragging:

=MID(A1,MAX((MID(A1,ROW($1:$255),1)=" ")*ROW($1:$255))+1,255)

Good point.

Rick
Reply With QuoteReply With Quote