Correcting Emails in an Excel Sheet

I've an excel sheet having too much data approx 36000 records. The issues are

1. I need email Ids to send emailers
2. Issues

1. 1. some of the emails are prefix with domain name and suffice with a number see this the email is xxxxx (removed for security reasons)
   2. some records have this the quote ''. xxxxx (removed for security reasons)
   3.In this there is "a" in the end xxxxx (removed for security reasons)
   4. some rows are having this type (([email protected],[email protected],[email protected],[email protected],z@_.d)
   5. Some row are having records like %[email protected]
   6. Some row are having this kind of records (%61%67%76%73%69%6e%63@%67%6d%61%69%6c.%63%6f%6d)
   
   I'm sharing sheet. I need clean sheet. I encounter this issue on daily basis is there any kind of solution for these problems.
   
   

I have removed your workbook for security reasons as it appears to contain REAL E-mail addresses.

Any data shared here on a public forum should be DESNSITISED for reasons of security. Sharing this sort of data in public could be contary to your company's and/or country's regulations.