Thread: Pharsing string from the right to the first space
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean Dean is offline
external usenet poster
  
Posts: 93
Default Pharsing string from the right to the first space
I would like to extract data from a cell based on everything after the first
space tothe left of the end of the data. ie Cell 1 contains "Mr. Dean L.
Davis", I would like cell 2 to extract everything from the last space to its
right. In this case "Davis".
I have looked but am missing it somewhere.

Thanks
Dean
Reply With QuoteReply With Quote