How to convert the names to related emails

Unknown

I have data in the main file and there are mixture of PM names and emails .I want to extract few of them from the list but the problem is since they are not same I mean mixture of email and Name not able to build a precise formula. Help in converting them to proper fromat before extraction.

KPH

Are you able to share an example of what the column contains so we can understand the problem? If this is real people's data, can you use some fake names and emails and make a list that is similar? Then another list showing what you want to achieve.

You might be able to utilize the FIND function to look for @ signs or something along those lines.