Formula Help

  • Thread starter Thread starter Greg Rivet
  • Start date Start date
G

Greg Rivet

I need help with a formula to extract the last name from this example:

(e-mail address removed)

What I am looking for is "Smith", which will always be between "." and "@".
TIA

Greg
 
With your example, email address in cell A1
=MID(A1,SEARCH(".",A1) + 1,SEARCH("@", A1) - SEARCH(".",A1) - 1)

Dan E
 
Dan, Laura and Leo, thanks for your help. I just about had it but you all
were exact with your help. I hope someday I can give back as much as you all
share with the group. Thanks again

Greg
 
Back
Top