Sorting by cell component?

[Sfinally]

I have a large spreadsheet of data, which includes a column of email addresses. I want to sort the sheet by the domain names of the email addresses, but they are all different lengths (if I can't sort I want to at very least isolate by domain name). Is there a way to sort the column by just looking for "@yahoo.com", "@gmail.com", "@hotmail.com" etc?

 

[West Man]

You will need a helper column to sort on. It can be created with: =MID(A1,FIND("@",A1),999) where A1 contains the email address. Note this assumes that nothing follows the domain name.

 

[Sfinally]

Thanks. What does the 999 in the formula do?

 

[West Man]

You are welcome. The 999 is the length of the returned text. I made it very long to be safe. The actual length is determined by the number of characters following the @.