Sort data in excel file and format address in columns -- 2

Job ID: 34637322

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. This needs to be formatted properly and duplicate city names in each row needs to be deleted.

I want this to be formatted so the address is sorted as

Company Name, Address, city, county and postcode. There are 756 rows to be formatted.
For eg. This is the first company formatted for you

AM Clinic, 23 CROWN STREET, Derby, Derbyshire, DE22 3UR

Attached is the excel file.

This needs to be done asap

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