Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Andy R
 
Posts: n/a
Default 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   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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   Report Post  
Andy R
 
Posts: n/a
Default

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   Report Post  
Karen
 
Posts: n/a
Default

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   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 08:25 PM
Data > Sort function amnesia? Dave D Excel Discussion (Misc queries) 1 November 29th 04 11:44 PM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 2 November 27th 04 02:55 AM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 0 November 26th 04 04:19 PM


All times are GMT +1. The time now is 10:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"