How to group e-mail adresess based on domain name?
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.
|