How do you sort a column of email addresses by domain name in Exc.

[Guest]

How do you sort a column of email addresses by domain name in Excel?

 

[Ron de Bruin]

Hi Andy

One way is to use a helper column with a formula like this
A1 have the email address

=MID(B1,SEARCH("@",B1,1),255)

Sort on the B column now

 

[Ron de Bruin]

Oops

A1 have the email address

B1

 

[Guest]

Hey thanks a lot. That worked great.

Andy

Oops


B1

 

[Karen]

How does this work?
Thanks

-----Original Message-----
Hi Andy

One way is to use a helper column with a formula like this
A1 have the email address

=MID(B1,SEARCH("@",B1,1),255)

Sort on the B column now


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Andy R" <Andy (e-mail address removed)> wrote in

message (e-mail address removed)...

 

[Ron de Bruin]

Hi Karin

=MID(B1,SEARCH("@",B1,1),255)

Mid use the Search function to give you the the first charcter of @
This is the start character
The 255 is the number of characters it will display(a lower number is Ok also)