Hi,
I'm a novice when it comes to Excel so please bear with me. I have Excel 2008 for Mac.

I have a spread sheet that contains for 300,000 email addresses in one column (file type is a .csv). From that list, I need to identify specific domain names so I can take the emails that contain that domain name and create a separate spreadsheet for them (for example out of the 300,000 emails I have, I need to find all those that are a Hotmail domain). I'm really not sure how to go about this, I've tried Hlookup and Vlookup but neither of them produced results that were accurate (it either gave me NA or said that the email contained hotmail when it did not).

Any help and formula suggestions is very much appreciated.

Thank you.