Cool. Thanks, Moo. That is awesome! You saved the day!!! That's going to work.

However, now I realized I left off the most important detail in my post above. I'm an excel novice. I've never used a formula before this instant. I have no idea what you mean by the solution you gave.

I have all of the email addresses starting in A1, as you recommended. I copy-n-pasted that lovely code you gave me into B1 and it does just as I need it to do. However, then I get lost. I understand I need it to be =LEFT (A2, SEARCH ("@", A2)...something but where do I put it and how does it work? I'm confused how do I get it to automatically do it for all of the B column?