Parse an email address

[Michael Connolly]

Hi,
I need to parse a email address to get the url.

Given a cell containing:
(e-mail address removed)

I need to extract:
reallycoolurl.com

Any help is GREATLY appreciated.
Thanks
MJC

 

[Guest]

Assuming your domains are shorter than 200 characters:

=MID(E10,FIND("@",E10),200)

Dave

 

[Guest]

If you want to strip out the @ sign,
=REPLACE(MID(E10,FIND("@",E10),200),1,1,"")

Dave