| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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?
|
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
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? . |
|
#6
|
|||
|
|||
|
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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
| Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
