Excel Expert to Compile List of Email Addresses from Hidden Characters

I have a list of 10K rows of data, that has Email Addresses in one of the column, but those Emails are hidden by ****... Example, one of the cell has following information: "Employees Employee Seniority level Email address Phone number Social Durrah Hamdan Associate Director - AI and Predictive Solutions Lead - d*****@[login to view URL] - Kamraj Subramanian Associate Director Director k*****@[login to view URL] - Yang Zhengzhi Data Scientist - zhe*****@[login to view URL] - Nina Alag Suri Founder and CEO CXO nina*****@[login to view URL] - " Your job is to split out those columns & replace those *** with given name... U may need to calculate how many characters with those *** then replace with the name as per given, certain * could mean . or -, these are common separator in email addresses. So, the use of intelligent formula is important to "guess" the right email. In the end, we need 1 row of data with Company, Name, Job Title, Email Address... If there are 5 email addresses from same company, it shd have 5 rows of data with 5 different emails (and name & job title) but with same company name. Although this could be done manually, but remember there are 10K rows, it might mean there could possibly 50K emails to be "guessed"... So Excel expert could do this quicker.