Extracting Specific E-Mail Addresses from a column

[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.

 

[Roger Govier]

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

 

[Van P.]

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.

 

[wac61]

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