Pulling email lists by domain

[sinasdf]

Hi,

I need help with pulling a column of email lists and then separating them according to domain.

For example, in column A, I would have several addresses such as:

[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]

For column B, for example, I want to have all the addresses from gmail.com, for C, hotmail.com, D, yahoo.ca, e.t.c.

The only two ways off the top of my head that could have helped were autofilters and delimeters, but those methods have limitations and really didn't help.

Thanks,
J

[steve.m]

Try: =IF(ISERR(FIND("@gmail.com",A2,1)),"",A2) for your column B

[sinasdf]

Hi Steve,

I made a few cell changes in you formula and it worked. I now know what to do with the other columns for the other domains.

Would you happen to know another formula that would bring back the addresses with the same name, but they would be next to each other, row by row?

The formula that you gave me pulled all the gmails from A and put them to B, but for all the emails that weren't gmail in A, there is a blank in B.

It's easier formatting and organizing for me if I could somehow get all the gmails all bunched up.

[tigeravatar]

sinasdf,

Attached is a sample workbook with a button assigned to the following macro:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[sinasdf]

Hi Tiger,

Thanks for your effort but unfortunately I'm not acquainted well with macros, so I don't use them as much. I also tried that and I got an error, but I appreciate your help.

I actually found an easy way to make the emails appear on top of one another after 'pulling', using the auto filter and selecting "non blanks".

Thanks again for your help folks!

-J