Sorting by email address?

[GLOpro]

How can i make excel sort by email address? But exclude the first part of the email address and only sort by the domain?

ie. name@company.com

Its easy to sort by name, but how do i make it sort by company/domain???

 

[Harvey]

the formula here gives the domainname of an emailaddress.

RIGHT(A1, LEN(A1)-FIND("@", A1))

you can then sort based on that.

 

[GLOpro]

the formula here gives the domainname of an emailaddress.

RIGHT(A1, LEN(A1)-FIND("@", A1))

you can then sort based on that.

Thanks Harvey for the speedy reply.

Just to ensure that i have understood this properly, this should be used in a new column that will then extract the domain name, thus allowing me to sort by that column?

 

[Harvey]

yeap. You can also use it inside some other formula, just the way you like it :wink:

 

[northwolves]

Add a new column for domains,,then sort ,then delete the new column

 

[Peter_SSs]

A. An alternative formula for the domainname is:
=REPLACE(A1,1,FIND("@",A1),"")

B. If you don't want/need lots of formulas, then another method to make the extra column to sort on is this:
1. Select the column of email addresses and copy/paste to an adjacent empty column.
2. Select the new column.
3. Edit|Replace...|Find what: *@|Replace with: leave blank|Replace All|OK|Close

 

[GLOpro]

Thank you very much, It is all working now.