Sort data in excel file and format address in columns

Job ID: 34617943

Budget: £10 – £20 GBP

Hi This is a super easy project.

Attached is an excel file with the company name in column 1 and the company address in column 2.

I want this to be formatted so the address is sorted as city, postcode and country. If you see row 1186 this is how I want the excel sheet to be formatted.

There are 1183 records (rows) so all of them need to be done.

Project outline
1. Separate the address into columns Company, address, city, postcode and country.
2. Please send me an example of one company so I can check
3. I will select someone today once you send me the example

Attached is the excel file

Sinder
Related categories: Visual Basic Data Processing Data Entry Excel Word