| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
