A
Andy R
How do you sort a column of email addresses by domain name in Excel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
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
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
R
Ron de Bruin
A
Andy R
K
Karen
How does this work?
Thanks
Thanks
message [email protected]...-----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 [email protected]> wrote in
R
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)
=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)