Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change InputBox Range Selection to Column Letter Selection | Excel Programming | |||
Copy Selection - Paste Selection - Delete Selection | Excel Programming | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Combo Box selection only shows bound column info after selection made. | Excel Programming | |||
How to create a selection list then display the selection in a cell | Excel Programming |