Need to split 400 house addresses to correct format

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)



Needs to be (in excel columns):

Unit: 2

House: 4507


Ending: Cres

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.

Thank you.

Skills: Excel, Data Entry, Data Processing, Web Search, Web Scraping

See more: usps address line 2, usps address format apartment, split address online, usps address format, address line 1/2 and 3 example, usps address format tool, address format usa, proper mailing address format, need list dentists email addresses forums, need paksitani businesses email addresses, correct format phone number getafreelancecom, need list millions email addresses, software house addresses pakistan, correct format sitemaps phpbb3, need personal trainers email addresses extracted internet, translation english spanish correct format, need gmail addresses follow format, restaurant menu correct format, autocad house drawings dwg format, need 1000 votes different addresses

About the Employer:
( 1 review ) Burlington, Canada

Project ID: #25440073

Awarded to:


okay sir i will convert the address into your mentioned format please contact me with the file i am ready to start now thanks.

$50 CAD in 1 day
(761 Reviews)

19 freelancers are bidding on average $70 for this job


Hello Sir, Ready to START now with a sample for the accuracy and quality check. I will perform an accurate update for Address and City by following all your directions and instruction and input all those details into More

$30 CAD in 1 day
(258 Reviews)

Its my kind of a job please send me the details so that I can send you a sample P.M me please................

$50 CAD in 1 day
(102 Reviews)

hey send me the file I can do it for you. I read the whole project description. please come to chat Thanks

$50 CAD in 1 day
(121 Reviews)

Hi can do ur specified task Have over 10 years of experience in data mining/ Web scrapping/ Scraping Bots/ Chrome/Opera Extensions I have done it all. Tell us your source and we will put it in excel for you, Or we More

$75 CAD in 3 days
(12 Reviews)

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.

$100 CAD in 1 day
(19 Reviews)

Hi, I can split 400 address in 6 column asap. I can start right now. Looking forward for your response. Regards, Chirag

$30 CAD in 1 day
(58 Reviews)

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.

$35 CAD in 1 day
(31 Reviews)

******7 year experienced data entry , PDF to Excel , Excel, word, typing, data scraping, Web scraping expert here. I can start your work right now. will work until you 100% satisfy. please message me so that i can show More

$75 CAD in 1 day
(10 Reviews)

hi sir i do know where to collect addresses e.g i am ready to start your job immediately pls knock me here now for further detail and also tell me which file format you need these addresses and you can pa More

$140 CAD in 7 days
(12 Reviews)

Hello sir I am interested in this project. I can complete this work within 2-3 hours. Please give me a chance and contact me for more discussion Thank you

$35 CAD in 1 day
(16 Reviews)

Hi. I am new to this site but I am in this typing field for past 5 years. my speed is 60wpm. I have done many conversion projects in word and Excel. I can show my work in chat. I can assure you the work will be done on More

$30 CAD in 1 day
(7 Reviews)

Hi, I am so much interested in taking this project up for you. I have over 6 years’ experience in Office suite and also have a good command over MS Excel which includes charts, advanced formulas, pivot table, Excel VB More

$70 CAD in 1 day
(1 Review)

I would like to help you sir I will put them into the correct side and give you ASAP.

$111 CAD in 1 day
(0 Reviews)

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

$110 CAD in 7 days
(0 Reviews)

I've explored and studied Information Computer Technology as it is my specialization track during secondary level of education that hasten my capability in this field. I've work different computer projects, been a : 1. More

$72 CAD in 3 days
(0 Reviews)

Hey I'm faizal looking for work as I'm new here i want to grow myself i just go through your content and I'm ready to work on it I'm here to make your work easy please feel free to contact me i hope I'll get the work t More

$30 CAD in 1 day
(0 Reviews)

Hi. You can count on me, I have time and experience to do the job. Thank you

$200 CAD in 7 days
(0 Reviews)

Hi there, I'm interested in your project and I can do your excel sheet work in a very short time. Thanks, Anurag

$30 CAD in 1 day
(0 Reviews)