selection

[dragonstats]

Hi All,

Being totally new to excel (actually I have never used it) I need to d
a simple task, but can not find a way to do it! I have an excel shee
with just over 1 million email addresses, but this email addresses ar
mixed and I want to separate them by countries. I would like to find al
addresses that end with .fr or .uk or .com and move these addresses to
different worksheet, how can I do that?

I have no programing skills, so I don't know how to setup a macro.
know that it is difficult, and that the best would be to follow a cours
in excel, but unfortunately this is pretty urgent and time is what I d
not have, so if anyone has the answer that would be very muc
appreciated?

Thank you kindly for any help..

 

[Claus Busch]

Hi,

Am Tue, 19 Feb 2013 12:15:37 +0000 schrieb dragonstats:

Being totally new to excel (actually I have never used it) I need to do
a simple task, but can not find a way to do it! I have an excel sheet
with just over 1 million email addresses, but this email addresses are
mixed and I want to separate them by countries. I would like to find all
addresses that end with .fr or .uk or .com and move these addresses to a
different worksheet, how can I do that?

filter your data:
Data => Filter => Text Filters =Ends with => .com and copy to a new
sheet.
Same procedure for .fr and .uk


Regards
Claus Busch