Formula Help

G

Greg Rivet

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

[email protected]

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

Greg
 
D

Dan E

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

Dan E
 
G

Greg Rivet

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
 
Top