View Single Post
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default 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