Sort data in excel file and format address in columns -- 2
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
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