Extract Text--Hopefully Easy!

[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!

 

[Vasant Nanavati]

=RIGHT(A1,LEN(A1)-FIND("@",A1))

 

[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

 

[rae820]

it worked...Thank you soooo much!!!

 

[rae820]

it worked...however i was wondering if you could explain *why* it
worked???