Need Help Matching and sorting multiple columns

I need help sorting a contact list of 3000 + so the emails match with the company name, and first and last name of the contacts

Column A is Email and Matches column C & D. Column B matches with Column E. I need A to match with B-E.

I've attached an example.Example Spreadsheet.xlsx

Thanks!

Hi KA1485

Welcome to the forum

You have got yourself one heck of a job! It will be really easy if all email addresses were set to the same rules. That just isn't going to happen.

I have written down some formulas that will extract certain data from the email address that might help you.

Do not forget to make the entries into text before you start sortin, or you will get some very interesting results.

Good luck

Regards
Alastair

As noted above, parse the data in Column A into Company First and Last name.