Sort Email by domain and move domain group to new list

**grandparocks** · 01-06-2013, 07:37 PM

Hello, I have a long list of contacts that I have on a spreadsheet. I want to sort the list by domain, then transfer the different domain group to a separate list. All of the email address are in column A
Example:
[email protected]
[email protected]
[email protected]
ect. ect.
I hope I explained this so you understand what I am trying to accomplish
Thanks for your help.

**FDibbins** · 01-06-2013, 07:52 PM

I know this isnt what you asked, but have tou considered using filters? you can use a text filter/ends with. alternatively, in a helper column, add this, copied down...
=MID(A1,SEARCH("@",A1,1)+1,99)

you canthen either sort based on the helper, or filter based on the helper

**alansidman** · 01-06-2013, 08:03 PM

In B1 type this formula and copy down.

=MID(A1,FIND("@",A1,1)+1,LEN(A1)-FIND("@",A1,1)-4)

**grandparocks** · 01-06-2013, 08:04 PM

Thanks FDibbins, but I am too new to this to understand what your asking me to try. I have done a filter to "find @yhoo.com and found all the email from yhoo domain, but do not know how to move them to another workbook.
as a group.

Also don't understand code tags,