View Single Post
  #3   Report Post  
Domenic
 
Posts: n/a
Default

Assuming that Column A contains your data, enter the following formula
in B1 and copy down:

=RIGHT(A1,LEN(A1)-FIND("@",A1))

Then, select Column A and Column B, and sort by Column B.

Hope this helps!

In article ,
"Zip code help" wrote:

One of my files contains a field of Emails. I want to sort it by the ISP, not
the beginning of the text. so if an email is , I want to sort it
so I can view all the , etc. -- the only way I know how
to sort is by Ascending/descending and it sorts by the beginning of the text.
Thanks!