Identifying value out of data set

[SILVER36]

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.

[tlafferty]

Several approaches can be tried. You need fast, I'd look into a "helper" column with a formula designed to find the @ symbol. Some email domains may have .net as well as .com etc. So I'd suggest a filter on everything to the right of the @ symbol. First, add a formula like this to a column to the right of your data.
=MID(A2,FIND("@",A2)+1,LEN(A2)-FIND("@",A2))

I'm assuming your emails are in the A column, that A1 contains a header such as emailaddress.

Then, click anywhere in your data and click the data tab in the ribbon and choose filter. You can then use the dropdown to select specific domains.

[tigeravatar]

SILVER36,

Welcome to the forum!
For something like this you can use an filter for specific text. Here's some steps for what you need to do:

Click the header of the column you want to filter and go to Data -> Filter
Click the drop-down arrow on your header and select Text Filters -> Contains
Type "@hotmail" -> OK
Now only the rows which have "@hotmail" in the email address are shown, and you can copy/paste that data to a new worksheet.

[SILVER36]

Thank you tigeravatar and tlafferty! I used a combination of both those methods to get my data.

[Cutter]

@ SILVER36

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.