how do I sort email address by ISP?
On Mon, 14 Nov 2005 07:00:02 -0800, "lucy"
wrote:
I a trying to sort a customer list with email addresses by ISP to group like
ISPs together in Excel 2003
ISP's may or may not be a part of an email address, and may not even be
discoverable if someone has a domain hosted on a remote server. If you mean to
group them by domain, then the easiest way would be to use a "helper" column
and sort on that.
For example, with your data in A1:A10000:
B2: =MID(A1,FIND("@",A1)+1,255)
and copy/drag down to B10000. Then Data/Sort on Column B.
--ron
|