Extract Text--Hopefully Easy!

R

rae820

i have an e-mail address that I would like to extract the text after the
@ sign. Cannot use text to columns. Need a function so that way every
time I enter an email address, it will continually be updating instead
of actually going through and using the text to columns option each
time.

Any help would be great!
 
R

Ron Coderre

Try this (if the address is in cell A1):

=IF(ISERROR(FIND("@",A1)),"Invalid Email",MID(A1,FIND("@",A1)+1,255))
Does that help?

Regards,
Ron
 
Top