Parse Full Names and Research Email Contact Addresses

Part 1) Split full names into FirstName and LastName fields. This includes removing middle initials. For instance, Mary A. Smith would be correctly parsed as FirstName: Mary, LastName: Smith. The FirstName will be merged so that an email might say: "Dear Mary" and NOT "Mary A." nor "Mary Smith". Part 2) Find email addresses for these individuals. The people being researched are real estate agents, and thus want to be found and contacted. It is expected that finding an email address may take between 30 seconds and 3 minutes each. We do NOT want agency or company email addresses, we want email addresses that go directly to the people on the spreadsheet. It is ok to skip an entry if an email is proving overly difficult to find. Recommend searching on {fullname} {city} email, for instance: "Lily Acain Kahalui email" The initial project is for 25 entries. This is a trial to find a top-notch freelancer who provides quality results with attention to detail at a competitive price. A successful project will result in a phase two project of 1,400 entries. The winning freelancer needs to provide a Google account / Gmail, and will receive access to a Google sheet for editing. Thank you!