On Fri, 14 Oct 2005 09:14:09 -0700, "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!
Use a helper column to extract the ISP. If email names are in A1 enter
in B1
=RIGHT(A12,LEN(A12)-FIND("@",A12))
copy down as appropriate then sort on column B
HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________