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.