Alphabetizing E-mail Addresses

D

Don Guillett

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

Niniel

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?
 
C

Chip Pearson

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)
 
B

Beccy

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