Have an excel list of 400 addresses.
It has the address and city in 2 columns.
What needed is for it to be converted into 6 columns:
1. unit number (blank if it is not in address)
2. house number
3. street name
4. street ending (ex. street, avenue, road)
5. postal code (need to look up on google etc, all addresses are Canada)
6. city (already separated)
2-4507 AQUARIUS CRES NIAGARA FALLS
Needs to be (in excel columns):
Postal Code: L2E 5P7
City: Niagara Falls
Important thing to note: Not all addresses are exactly in this format (with unit number in front of house number). Some may be like 235 Example st unit rr3. In this case you would have to put rr3 as unit number.
Deadline: 2-3 hours from now.
19 freelancers are bidding on average $70 for this job
Ready to start your work right now. I will impress you with my work and will do good job for you. 10 Year experienced in Excel, word, typing, data scraping, Web scraping.
Hi, I can split those 400 addresses to the correct format. I assure you 100% accuracy. I am very detail-oriented. I can start right now and I can finish this within 2-3hrs. Let's talk to discuss more.
Hey my I take this opportunity to do this job. I'm expert in MS [login to view URL] I'm available 24/7 I can do this task easily, Infact I can start working right now