Alphabetizing E-mail Addresses
 

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,

Alphabetizing E-mail Addresses
 

How about a helper column that finds the @ and places all to the right in
the cell. Sort by that col

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"timfear" wrote in message
...
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,

Alphabetizing E-mail Addresses
 

You could rip the addresses apart with Data\Text to Columns..., sort by
domain and then re-assemble, but I suspect that's not exactly what you are
looking for, is it?

Alphabetizing E-mail Addresses
 

Insert a new column next to your email addresses and enter the formula

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

in the first cell in that column and copy down as far as you need to go.
Then, sort the rows using that column as the sort key.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"timfear" wrote in message
...
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,

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,