selection
 

Hi All,

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?

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

Thank you kindly for any help...

selection
 

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2