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:

(E-Mail Removed)
(E-Mail Removed)

Thanks,

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
(E-Mail Removed)
"timfear" <(E-Mail Removed)> wrote in message
news:1FE4CB92-ABB8-43BD-B79D-(E-Mail Removed)...
> 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:
>
> (E-Mail Removed)
> (E-Mail Removed)
>
> Thanks,

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?

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" <(E-Mail Removed)> wrote in message
news:1FE4CB92-ABB8-43BD-B79D-(E-Mail Removed)...
> 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:
>
> (E-Mail Removed)
> (E-Mail Removed)
>
> Thanks,

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:
>
> (E-Mail Removed)
> (E-Mail Removed)
>
> Thanks,