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/117411-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

Bob Umlas, Excel MVP

Parse an email address

=MID(A1,FIND("@",A1)+1,255)

"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 04:46 PM.