Do some Excel Work - Split Address into Address, City, Sate, Zipcode
$10-30 USD
Slutfört
Publicerad över sju år sedan
$10-30 USD
Betalning vid leverans
Hello, I have a spreadsheet with around 6000 US addresses in it in a 1 cell format each. I need to separate the content of the cell into: Address, City, State, Zipcode.
please let me know if that is something you can or would like to do!
Sample of data: 1736 W ohio st 3 R Chicago IL 60622. This should be:
Address: 1736 W ohio st 3 R
City: Chicago
State: IL
Zipcode: 60622
Thanks,
Sam
is there comma or any thing seperating the addreses? if yes i can do with some formula, if they are blank then i can do manually but i will do for $200 and 3 days, thanks
Hi Sam. I am a full time excel expert and am rated best service provider in excel projects, I saw the example you just mentioned. Unfortunately, there is no special character (, . : etc) so it will probably take a day to separate 6000 address from one column to there respective columns. Please check my feedbacks for my expertise in similar excel formatting projects done. Ready to start right away. Looking for more discussion via chat. Best, Ethan
Hi Sam,
I've done a similar work before using excel. Kindly refer to my related projects at
https://www.freelancer.com/projects/Data-Entry-Excel/adress-clean-split-cells.html
https://www.freelancer.com/projects/Excel/Excel-Data-Tidy-Sorting/
https://www.freelancer.com/projects/Data-Entry/Mail-List-Cleaning/
Best regards,
Hoang
very easy for me,i can complete in 2 hour ,so please contact me,thanks,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.
Hello Dear, I am an expert in Data Entry, Excel, PDF and I am really interested in your project. I am available to start working on it now. I work efficiently and will finish in a timely manner and will provide high quality work. I have great researching skills and would gladly work on your project. I am waiting to your quick positive reply and if you have any questions, feel free to ask me.
Hello Sir,
This is very easy job for me i will take maximum 2 hours and your job will be as you require. Plz consider me for this job Thank you
Amir Ishfaq
HI,
With reference to your proposal, I UNDERSTOOD YOUR REQUIREMENTS. Besides my excellent oral and written communication skills, I have cognate experience in typing (80 words/minute), in data mining (web scraping), and in data entry (using Microsoft Word and Microsoft Excel). I would be very pleased to assist you to carry out the EXCEL task. I look forward to hearing from you soon.
Warmest regards
Amiable Writer
hi i am expert i will do that 100% accurate its very simple work for me
I am skillful in Data Mining, Data Scraping, Data Entry, Data Conversion. Data Typing, Excel Entry.
It would be great honor for me work with you.. I can guarantee 100% customer satisfaction with all my work deliverable.
Hire me and you will never be disappointed
Hello,
I would like to work with you on this project.
I am currently available and can start immediately.
I have read your description and I see that It is easy to generate the address data in the format you desire. I can do that in either Excel VBA or C#.Net (stand alone application).
The result could go into a new Excel tab (sheet) or go to a text file with tabs or commas (CSV).
We can store the data in an excel in tabular format, this way you can have a structure akin to a database, where you can filter all rows in California for example.
It would help if you could provide more details.
I promise excellent quality and your complete satisfaction.
If you have any questions or have a suggestion for me to make my bid better suite your needs, please let me know.
Thank you.
Regards,
EK
MCP (Microsoft Certified Professional),
MCAD (Microsoft Certified Application Developer),
MCT (Microsoft Certified Trainer) and
B.Sc. In Mathematical Statistics and Computer Science
18+ years In Software Development in Fortune 100 Companies
such as Texas Instruments UK, EDS Canada, GM Canada
Quality is key
Hi, I'm Raphael a professional freelancer and a data entry expert. I saw your job advert and description and I indicated my interest to work for you because I have all that it takes to do a very satisfactory job. I am really good in typing words and inputting data in any specified place. I am equally fast when typing and this I believe will make me do a very wonderful job and which will surely satisfy your taste. I deliver at the prompt time and available whenever needed. Hire me. Thanks.
Hello Sir,
I am an accurate freelancer who can so this job perfectly, free of any errors. Everything will be revised to make sure it is done correctly. You can check the reviews of my previous employees (53 Reviews /w 5-star rating). These vouch for my professionalism, dedication towards client satisfaction and communication.
I hope you consider my bid, and that we can discuss the project furthermore via chat.
Thanks in Advance & Best Regards,
Ehab Wassily
Hey there! my name is Thiago and i'm an expert in excel.
i can easily separate the content into different cells and for a low price.
pick me and i'll start right away, i'm currently not working on anything so this job will be my priority.
looking forward to hearing from you.. thanks!
Hi there,
I'd love to help you pep up your project. I’m a proficient Data Entry professional. I have got advanced Excel skills to deal with complicated tasks. I can get your job done within five hours.
If I have an opportunity to work with you, I can assure you of flawless delivery. Hope to hear from you soon.
Regards,
Md. Shahin Iqbal
Hi
I have read your project description and you are looking for someone to organize details on your excel.
I would love to do that for you, I am a speed typer with a 60 WPM minimum speed and have above experience on excel.
Please give me more description about the project and your fair budget.
Looking forward for your response.
Mosiah