Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does Excel not recognize email address? | Excel Discussion (Misc queries) | |||
Split email address into seperat columns | Excel Worksheet Functions | |||
How to format a cell as email address | Excel Discussion (Misc queries) | |||
stop automatically making email address | Excel Discussion (Misc queries) | |||
Remove Email address header | Excel Discussion (Misc queries) |