Maverick27
Active Member
- Joined
- Sep 23, 2010
- Messages
- 329
- Office Version
- 2013
- Platform
- Windows
Attn all Excel Gurus
I have an Excel sheet of 500K Email Addresses.
How do isolate all company addressess eg addresses which DON'T have the following domains ?
@Yahoo ;
@gmail ;
@Hotmail ;
@Live ;
@ymail ;
@msn
Anyone care to share a Excel function or Macro to filter out the company address domains.
Below is a screenshot of the Excel list.
Thanks in Advance.
I have an Excel sheet of 500K Email Addresses.
How do isolate all company addressess eg addresses which DON'T have the following domains ?
@Yahoo ;
@gmail ;
@Hotmail ;
@Live ;
@ymail ;
@msn
Anyone care to share a Excel function or Macro to filter out the company address domains.
Below is a screenshot of the Excel list.
Thanks in Advance.