Thread: How do I extract the last name in Excel, from a list of names lik.
View Single Post
  #1   Report Post  
RobertC
 
Posts: n/a
Default How do I extract the last name in Excel, from a list of names lik.
Trying to extract last name from a cell (db field) which contains names like:

John Doe
John B. Doe
J.B. Doe

Various combinations of formulas such as =Right(C17,Len(c17)-FIND(" ", C17))
Can't find the right combination to do the job.

Thanks


Reply With QuoteReply With Quote