View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joerg Mochikun Joerg Mochikun is offline
external usenet poster
 
Posts: 104
Default 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.