How to group e-mail adresess based on domain name?

Hi, I have a spread sheet with a large number of E-mail adresses we are using
for an e-mail out and i was wondering how i can group them based on the
domain name in the e-mail adress i.e after the @ symbol. Simply grouping them
doesnt return very reliable results and its important that they are grouped
properly and also sorted into alphabetical order. Any help would be greatly
appreciated.

Cheers,

David.

G'day David

Check Ron DeBruins Website

http://www.rondebruin.nl/sendmail.htm

HTH
Mark.

Suppose your addresses start in A1, put this into B1:
=RIGHT(A1,LEN(A1)-FIND("@",A1))
Copy down as needed and, select everything and sort by column B.

Not though sure how you want to group.

JM

"DavidG" wrote in message
...
Hi, I have a spread sheet with a large number of E-mail adresses we are
using
for an e-mail out and i was wondering how i can group them based on the
domain name in the e-mail adress i.e after the @ symbol. Simply grouping
them
doesnt return very reliable results and its important that they are
grouped
properly and also sorted into alphabetical order. Any help would be
greatly
appreciated.

Cheers,

David.