Advanced Excel Sheet Work (Split Address Cell to Seperate Columns
$10-30 USD
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.
Project ID: #5547727
About the project
Awarded to:
hi sir, we will do in a few minutes.,please send the file......................................................
34 freelancers are bidding on average $25 for this job
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.
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
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.
Hi: I will do this project for free but just write me a good feedback. Please look my portfolio to gauge my excel skills
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.
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
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.
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
Hi there, I can do this job. Looking forward to start right now. If interested pls reply asap.....thanks regards: Mandeep Singh
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
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
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
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
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