Address Separation

We have several Excel files that the need the address separated. There is one field with street address, (and in some cases p o box and street address), city, state, zip and country. I need this information put into 5 fields, address, city, state, zip code and country. The field that needs to be changed is the field labeled (D Address). When completed, the addresses, city, state, etc., must line up with the existing data. I'm attaching a sample of the data. Please take a look at it and see what you can do. I would be more likely to hire you if you can send me a sample of how the data would look after you've completed it. I have 5 files each containing approximately 50,000 records. You can bid on an individual file or all 5. Thanks