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