View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Beccy Beccy is offline
external usenet poster
 
Posts: 4
Default Alphabetizing E-mail Addresses

I would add a new column into your spreadsheet with the following formula:

=MID(A1,FIND("@",A1)+1,10)

Where cell A1 is the first email address. Then copy this formula down. This
will then show the text after the @ and allow you to the sort this column in
the normal way.

"timfear" wrote:

I've looked around for this and couldn't find an answer. I'm trying to
alphabetize a list of e-mail address but want to do it by domain, so after
the @ sign. How can I do this?

Example:




Thanks,