Data Entry. Create Excel Spreadsheet from List

I need an Excel spreadsheet created from 2 contact lists, attached as PI#1 and PI#2 . Each list contains information that must be entered into separate fields in the spreadsheet. I have included the spreadsheet with 3 contacts from "PI#1" already inserted as an example. Important: note how the name of each contact is formatted in the contact list but needs to be entered into the spreadsheet: 1. In each listing the "last name" of the person is listed first, before the comma. 2. The next name after the first comma is the only name we need; do not include the middle name or suffix. For example, the name in the contact list appears like this: "Harrell, Leonard Scott, Jr." "Harrell" would go into the "Last Name" field in the spreadsheet and "Leonard" would go into the "First Name" field. Leave out the rest of the name. Lastly, the zip codes in each list are listed like: 12345-XXXX Omit the "-XXXX" We just need the first 5 numbers. Please see the included spreadsheet for further clarification on how we need the name and zip codes formatted. If you do not understand something, do not hesitate to ask questions. You must be EXTREMELY accurate and error free. I ask that you check your work before returning deliverables to me. Please review the contact lists and the entire scope of the work before submitting a bid and a completion deadline. ## Deliverables 1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement). ## Platform MS Excel