|
How do you sort a column of email addresses by domain name in Exc.
How do you sort a column of email addresses by domain name in Excel?
|
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 wrote in message ... How do you sort a column of email addresses by domain name in Excel? |
Oops
A1 have the email address B1 -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in 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 wrote in message ... How do you sort a column of email addresses by domain name in Excel? |
Hey thanks a lot. That worked great.
Andy "Ron de Bruin" wrote: Oops A1 have the email address B1 -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in 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 wrote in message ... How do you sort a column of email addresses by domain name in Excel? |
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 wrote in message news:105DDF4F-0BF9-44D9-BA12- ... How do you sort a column of email addresses by domain name in Excel? . |
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) -- Regards Ron de Bruin http://www.rondebruin.nl "Karen" wrote in message ... 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 wrote in message news:105DDF4F-0BF9-44D9-BA12- ... How do you sort a column of email addresses by domain name in Excel? . |
| All times are GMT +1. The time now is 08:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com