Excel - get email id based on First and last nam

I have group of email ID in a single cell, want to select a particular email id based on First and last name in Excel. Can you help?