Extracting Specific E-Mail Addresses from a column

  • Thread starter Thread starter wac61
  • Start date Start date
W

wac61

Hi Guys, I need a little help. I export data from a xml source and paste
into Excel 2003, in column A I have e-mail addresses with different
domains eg: @domain.com, domain.net, domain.com.au
I what I need to do is to extract only 1 name eg: @domain.com.au
or sort that column so that all those names are together. This contains
about 3000 addresses and 7 different e-mail domains the worksheet has 3
column: Email Address, Hours, and Data.
Any help would be a great help.

Thanks Mal.
 
Hi
You could highlight the headings, then
Data=>Filter=>Autofilter
Select the drop down on Email address and choose Custom
Select from left drop down =>Contains
In the righthand pane type domain.com.au

This will give you your filtered list of data
 
Mal,

If the domain names are in column A1 thru A3000, copy and paste this formula in an empty column =IF(ISERROR(MID(A1,SEARCH("@domain.com.au",A1,1),20))," ",MID(A1,SEARCH("@domain.com.au",A1,1),20)).

HTH

Van P.



----- wac61 > wrote: -----

Hi Guys, I need a little help. I export data from a xml source and paste
into Excel 2003, in column A I have e-mail addresses with different
domains eg: @domain.com, domain.net, domain.com.au
I what I need to do is to extract only 1 name eg: @domain.com.au
or sort that column so that all those names are together. This contains
about 3000 addresses and 7 different e-mail domains the worksheet has 3
column: Email Address, Hours, and Data.
Any help would be a great help.

Thanks Mal.
 
Thanks for your quick response, Van tried that formula but it came up
with errors thanks anyway. Roger yours worked a treat and you have now
saved me 3hrs of work time I would like to thanks for your help it is
appreciated.

Thanks Mal
 
Back
Top