Thread: Extract Surname from text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nc nc is offline
external usenet poster
  
Posts: 119
Default Extract Surname from text
Can you help me write a formula to extract the surname for a text.

For example,


Text

1. Peter V Crazy
2. James Van-Cleef
3. N N M B Chan

Results

1. Crazy
2. Van-Cleef
3. Chan

Thanks.


Reply With QuoteReply With Quote