Thread: Seperate last name from a cell with full name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Seperate last name from a cell with full name
Try this...

=MID(A1,FIND(" ",A1)+1,50)

--
Biff
Microsoft Excel MVP


"Ty" wrote in message
...
Cell A1 has "John Doe", what formula can use to get the last name only in
cell B1?
--
Thanks, Ty


Reply With QuoteReply With Quote