Access Keys:
Skip to content (Access Key - 0)

Sort tables in Excel by Email address domain name

This concerns lists of email addresses (username@domain.TLD), where the client wants to be able to sort the list by domain rather than just the first letter of the address.

So if you’ve got username@domain.TLD as an email address, you want to get just the domain.TLD

With email address(es) in column A enter this formula in column B:

=RIGHT(A1,LEN(A1)-FIND("@",A1)) (Excel code)
=RIGHT(A1;LEN(A1)-FIND("@";A1)) (OpenOffice Calc code)

This works by using the FIND function to search for the @ and then deducting that off the length of the string using the LEN function. Then using the calculated total just take that many characters from the RIGHT of the string.

IS&T Contributions

Documentation and information provided by IS&T staff members


Last Modified:

May 22, 2014

Get Help

Request help
from the Help Desk
Report a security incident
to the Security Team
Labels:
c-excel c-excel Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
Feedback
This product/service is:
Easy to use
Average
Difficult to use

This article is:
Helpful
Inaccurate
Obsolete
Adaptavist Theme Builder (4.2.3) Powered by Atlassian Confluence 3.5.13, the Enterprise Wiki