E-mail Sort
 

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

E-mail Sort
 

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

On Jan 22, 2:19*pm, tonyalt3 wrote:
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

E-mail Sort
 

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))
--
David Biddulph

"tonyalt3" wrote in message
...
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