|
Posted to microsoft.public.excel.programming
|
|
|
seggregating email addresses
http://www.rondebruin.nl/copy5.htm
--
Regards,
Tom Ogilvy
" wrote:
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.
|