Advanced Excel Sheet Work (Split Address Cell to Seperate Columns

Completed Posted Mar 12, 2014 Paid on delivery
Completed Paid on delivery

I have a data set 20,000 rows of data.

The address, postcode and country is all in one cell. Some of the cells have commas, some don't. Please see the attached sheet.

This is not a manual job, hence the budget, but needs someone who can split cells using functions, not the simple text to columns function.

See the attached data as an example, this is only a short excert.

If you can split Column C using functions then the job is yours.

Excel

Project ID: #5547727

About the project

34 proposals Remote project Active Mar 12, 2014

Awarded to:

rohitagarberg

hi sir, we will do in a few minutes.,please send the file......................................................

$10 USD in 1 day
(341 Reviews)
6.4

34 freelancers are bidding on average $25 for this job

Teloquence

I can write a small VBA code to do this. Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$30 USD in 0 days
(326 Reviews)
7.6
deepbluetech

Hi, I can split the address the way you want with a bit of manipulation using Excel formulas/macros. Please confirm and provide the data file to be split. Regards, Arul

$30 USD in 1 day
(173 Reviews)
7.3
Wezigners

Hi, Send your full lists to me to start work. I will do both auto and manual process in this project. expert in data entry. Eagerly awaiting for your positive reply. Thanks, Jennifer.

$80 USD in 3 days
(167 Reviews)
6.8
aarifakhtar

Hi: I will do this project for free but just write me a good feedback. Please look my portfolio to gauge my excel skills

$10 USD in 1 day
(165 Reviews)
7.0
greggfletcher

I will be able to separated the data for you. It will take a few hours. If you are interested in my bid, please contact me. Thank You. Best Regards.

$30 USD in 0 days
(43 Reviews)
6.6
avinav606lx

Hey There, Thanks for posting the project. Its looks very much feasible and am Interested to do it. Next steps: Lets discuss the complete requirement and I can start to get this done via writing a script to do More

$27 USD in 1 day
(160 Reviews)
6.4
yourjmr

Hi! I am a freelance data mining and data entry expert from India having more than 10 years experience in all kind of data related services. I have a team also to work with me. I am well expert in this type of More

$30 USD in 1 day
(194 Reviews)
6.2
binaryromel

Hi there, I'm exert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, FARZANA PINKY.

$15 USD in 0 days
(106 Reviews)
6.1
rengrish

I have excellent experience . I have understood the requirement /Please check my past reviews and ratings. I assure you 100% accurate & quality job. I can give you a demo work. If you are 100% happy with my demo work t More

$30 USD in 1 day
(145 Reviews)
5.9
gokulanand

Hello, I can get this job using a VB macro. I can assure you to deliver this in the next 30 mins. Let me know if you are interested. Thanks

$24 USD in 0 days
(96 Reviews)
6.0
mandeeps207

Hi there, I can do this job. Looking forward to start right now. If interested pls reply asap.....thanks regards: Mandeep Singh

$25 USD in 0 days
(39 Reviews)
4.6
dank111

Hey, I can do this for you. I have not been bidding for quite a while but your project does interest me. If you are comfortable with me delivering the results by tomorrow, i.e., India time than I am on for this job. Ab More

$20 USD in 1 day
(11 Reviews)
4.6
yes0

I read through the job details extremely carefully and understand you’re required, for this I am absolutely sure that I can do the project very well. I can complete your project on time and within your budget. I More

$20 USD in 0 days
(52 Reviews)
4.0
MasterExcel

I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high More

$10 USD in 1 day
(9 Reviews)
3.5
kajteksolutions

Hello, I have an Excel Automation software specifically for this process. I will also do spot checks on the results for added efficiency. I am looking forward to your response. Sincerely, Kajtek * I am an i More

$30 USD in 1 day
(2 Reviews)
2.4
singhmak1990

Hi there, I am expert in excel data mining files. Looking forward to start right now. If interested pls reply asap..... thanks regards: Sandeep Singh

$20 USD in 0 days
(4 Reviews)
2.0
dionline

Hi, I successfully split the column C given in the attached file. I will show you the result through PM as there is no option to attach file without PM. I will do it within an hour and can start immediately. Let me kno More

$30 USD in 1 day
(1 Review)
1.4
grasya080888

Dear Hiring Manager, I would like to apply your job post. I am also who is a detail-oriented person. I think that I am the right person for the job. The 5 things made me different from other freelancer. 1. I fee More

$25 USD in 1 day
(1 Review)
0.0
bpetkovski

A proposal has not yet been provided

$30 USD in 0 days
(1 Review)
0.0
gauravkiitk

Reduced my bid also, since this is my first project and i have completed it. Do let me know if interested now. Just to update you again :- I have written a perl script to break the column C as mentioned in your prob More

$10 USD in 0 days
(0 Reviews)
0.0