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

D

DavidG

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.
 
J

Joerg Mochikun

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get domain from e-mail 7
Force e-mail rec'd from one specific domain to plain text 1
how to show only name and not e-mail address when sending/receivin 1
Send e-mail based on condition 1
Macro's to E-mail auto name selection 2
Taking out domain names out of e-mail adresses 1
Taking out domain names out of e-mail addresses 1
Outlook 2003: use of domain name to create rules 1

Top