E-mail Sort

  • Thread starter Thread starter tonyalt3
  • Start date Start date
T

tonyalt3

Is it possible to sort by e-mail address? For example, I have a
spreadsheet with name and e-mail and I want to sort by e-mail address,
but not by the begining of the address. Half are @yahoo.com, and the
other half are @gmail.com. I want to sort out all those that are
@gmail.com
 
One way is with a helper column. With your email addresses in column
A, put this in B1 and drag down

=MID(A1,FIND("@",A1)+1,999)

Select columns A and B and sort by column B. You can then delete or
hide the helper column.

Mike
 
You could use Autofilter with the custom criterion "contains" gmail.com or
"ends with" gmail.com

Alternatively you could use a helper column
=RIGHT(A2,LEN(A2)-FIND("@",A2))
 
Back
Top