Hi all. I am new and ignorant!!

I have loads of contact and I need to sort them into a workable database now. I have a list in excel and am interested in name, company & email. Since the list is 10K long, it's taking me forever to go through and sort out who goes into the "production" category, who goes into the "events" category etc. However, often, an events company will actually use "event" or "events" in their email. So, I want to know if it's possible to search for all the emails that have got the work "event(s)" in it and transport the whole role (since i need the names as well) onto another sheet.

Is this even possible?

I'd be very grateful for any help.