View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] maxirox@gmail.com is offline
external usenet poster
 
Posts: 3
Default seggregating email addresses

I have few email addresses of my friends in the range A1:F25 in
"Sheet1". I have added few blank worksheets with domain names
("Hotmail", "Gmail", "Yahoo", "Aol" etc). I have 10 worksheets with
different domain names. I want to seperate these email addresses in
"Sheet1" by their domain names and put it in the respective worksheets.


For instance if A1 contains , this email address should
be transferred in the sheet "Hotmail" in cell A1, the next email with
@hotmail should go in A2.