I have an excel file that has 787 lines of information. Each line has 4 pieces of information. ID, City, Name, and Postal Code Out of these 787, about 50% of the postal codes are not formatted properly. I need you to go through the excel file, and make sure all of the postal codes are arranged like XXX XXX some of them are not spaced properly like XXXXXX (that should be changed so that format is XXX XXX) Some of them have XXX XX (missing 1 character). For the ones that are missing a character for the postal code, I'll need you to look up the city name from the list and fix the postal code so it's XXX XXX. Out of the 787, I quick glance there looks like there is 40% that are ok, 35% need a space so they are formatted like XXX XXX and about 25% that need you to find the missing digit in the postal code I'll provide it in excel, you need to fix them and send me back the excel the same way I sent it to you but with the postal codes fixed
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).