Need spilt full address from a excel spreadsheet

Job ID: 33343530

Budget: $4 – $5 USD

I have excel spreadsheet where there are rows like 1400 who need to slip the full address, for example address, city, zip these three columns only. The cities in the full address are given in CAPITAL LETTER. Please check attached screenshot

I need it now.. urgent task but simple

Budget: $5

Related categories: Visual Basic Data Processing Excel Microsoft Office Excel Macros