ExcelBanter - Parse an email address

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Parse an email address (https://www.excelbanter.com/excel-worksheet-functions/117410-parse-email-address.html)

Michael Connolly

Parse an email address

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

Given a cell containing:

I need to extract:
reallycoolurl.com

Any help is GREATLY appreciated.
Thanks
MJC

Dave F

Parse an email address

Assuming your domains are shorter than 200 characters:

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

Dave
--
Brevity is the soul of wit.

"Michael Connolly" wrote:

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

Given a cell containing:

I need to extract:
reallycoolurl.com

Any help is GREATLY appreciated.
Thanks
MJC

Dave F

Parse an email address

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

Dave
--
Brevity is the soul of wit.

"Dave F" wrote:

Assuming your domains are shorter than 200 characters:

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

Dave
--
Brevity is the soul of wit.

"Michael Connolly" wrote:

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

Given a cell containing:

I need to extract:
reallycoolurl.com

Any help is GREATLY appreciated.
Thanks
MJC

All times are GMT +1. The time now is 10:05 AM.