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

--

Vasant

"rae820" wrote in
message ...

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!


--
rae820
------------------------------------------------------------------------
rae820's Profile:
http://www.excelforum.com/member.php...o&userid=24135
View this thread: http://www.excelforum.com/showthread...hreadid=378561