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