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

  • Thread starter Thread starter DavidG
  • Start date Start date
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.
 
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 do I sort in Excel by a root e-mail like @yahoo.com? 7
E-Mails to international Domain Names (IDN) 3
how to show only name and not e-mail address when sending/receivin 1
Single Quotes sometimes around e-mail addresses 5
How to import E-mails from Windows Mail into Outlook 2007 on Windows 7 22
Force e-mail rec'd from one specific domain to plain text 1
How to get domain from e-mail 7
How do I import Names of Windows files into an Excel Spread sheet 3

Back
Top