So much for taking an Excel class, I am at a loss.

I have a list of 30,000 email addresses. All are in column A.

I want to tell Excel to:

move all hotmail.com addresses to column B;
move all Yahoo.com addresses to Column C;
move all MSN.com addresses to Column D;
move all gmail.com addresses to Column E;

and so on...

I need someone to keep it simple for me because looking through the forum my head is spinning. I need to know exactly what to post as the formula? Macro?

Thanks to anyone who has an answer.

Candi