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.