Data Clean-Up - 5,000 rows

Hi there! I need 4,000 rows of data cleaned up over the next ~3-4 days. The data consists of - email recipient - company name - contact names (multiple in a up to 2 cells which may not match the email) What you'll need to do is - Clean-up the company name (remove elements like "Group", "United State", "Ltd", etc.. - Identify and clean-up the recipient's first name via the following steps: >> If the email is in the format "first name. last name" use the first name from the email as the recipient fist name >> If the email is in another format, but still linked to an individual (e.g. dlohrm) try to find the individual in the contact names columns and use the corresponding first name >> If the email is in a generic format (e.g. accounts) use the first name of the first individual in the contact names columns >> in all other cases leave contact names blank