|
|
#2
05-31-2017, 06:43 AM
|
|||
|
|||
In I2 enter:
MID(C2,FIND("@",C2)+1;LEN(C2)) and copy down. Name range with these formulas d. In J2 enter the following array formula: =IFERROR(INDEX(d,MATCH(0,COUNTIF($E1:E$1,d),0)),"" ) Remember to hold down Ctrl and Shift before pressing Enter. Copy the formula down. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 need to extract email addresses from excel files
|
dunndealpr | Excel | 3 | 06-07-2013 08:29 AM |
|
Incorrect Email Addresses
|
StuartDAB | Outlook | 1 | 03-04-2011 07:01 PM |
|
Duplicate Email Addresses
|
lh66 | Outlook | 2 | 02-20-2011 07:32 PM |
|
Export all email addresses
|
Rich12345 | Outlook | 1 | 02-02-2011 10:16 AM |
| How Many Email Addresses Can You email at one time in Outlook | zinfandel72 | Outlook | 2 | 08-04-2008 06:39 AM |
Windows 10 
Office 2016
Threaded Mode