View Single Post
  #2   Report Post  
bpeltzer
 
Posts: n/a
Default

Create a 'helper column' in which you tease out the ISP. Ex: if the email
address is in A2, enter =RIGHT(A2,LEN(A2)-FIND("@",A2)) in B2 to calculate
just the ISP. Autofill that formula to each row, then sort based on the new
column.

"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!