Parse an email address

  • Thread starter Michael Connolly
  • Start date
M

Michael Connolly

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

Given a cell containing:
[email protected]

I need to extract:
reallycoolurl.com

Any help is GREATLY appreciated.
Thanks
MJC
 
D

Dave F

Assuming your domains are shorter than 200 characters:

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

Dave
 
D

Dave F

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

Dave
 
Top