Find Jobs
Hire Freelancers

Make the Script or Macro to clear the Excel sheet v2

$10-30 USD

Closed
Posted about 6 years ago

$10-30 USD

Paid on delivery
Hello all, I need an Excel/Python expert to do the following: Remove all rows under "Owner1" with the following: LLC, Corp, Corporation, Assoc, Associates, Properties, Rt, Ft, Nt, Inc and any rows with “T” at end of name (ex. “Green Line T”) or “Est” at end of name (ex. “Green Line Est”) You will then put all of these into separate Excel sheet. For the remaining "Owner1" and "Owner2", you will create separate columns for Owner1 and Owner2 First Name, Last Name, Middle Name and Middle Initial(s). If there is a "Tr" at the end of any name, you will remove it and add it to a new column labeled "Trustee". The Trustee column should be the next column after the last name. If the first or last name is hyphenated, keep both. (ex. Jing-Ling Jones or Bob Jones-Johanes) If the 5 digit "Zip" and "Owner_Zip" field has an additional 4 digits (ex. 02144-3449) then put the last 4 digits in a new column next to the Zip/Owner_Zip fields.
Project ID: 16250569

About the project

37 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
37 freelancers are bidding on average $28 USD for this job
User Avatar
Hello, My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete. Also I will provide you with a sample work before you may please consider awarding me the project. Thanks, Jay
$50 USD in 0 day
5.0 (579 reviews)
8.2
8.2
User Avatar
I have a large and successful hands-on experience in processing and analyzing data in Excel Your task is clear to me and I am ready to execute the project for the 25 USD
$25 USD in 1 day
4.9 (56 reviews)
5.6
5.6
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered eight excel vba projects in the past one month. Willing to take up your task. Looking forward to working with you. Thank you, Regards.
$25 USD in 0 day
5.0 (36 reviews)
5.1
5.1
User Avatar
This bid is to write Python code to implement the excel data transformation details described in the project description.
$30 USD in 1 day
5.0 (17 reviews)
4.9
4.9
User Avatar
Greeting, I have understood your Make the Script or Macro to clear the Excel sheet v2 task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Processing, Excel, Excel Macros, Excel VBA, Python
$50 USD in 1 day
4.8 (14 reviews)
5.3
5.3
User Avatar
I am well equip to this kind of task, can handle it pretty well. I already done related to this job before. Let me know the best of your time so we can discuss further based on your requirements.
$148 USD in 8 days
4.8 (25 reviews)
4.8
4.8
User Avatar
Hi, Please note, I'm not a phyton expert. I am an excel expert. I can do what you want but only in excel. If you'd like to, I'm waiting your reply to discuss further. thanks
$25 USD in 0 day
4.9 (36 reviews)
4.4
4.4
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
5.0 (6 reviews)
3.7
3.7
User Avatar
Hello, I am interested in your offer and I am ready to cooperate. I have experience in writing macros VBA for Excel.
$20 USD in 1 day
4.8 (8 reviews)
3.1
3.1
User Avatar
Hi, I am good at data processing by using python 3.6. Could you please give me your excel file and I will solve this problem for you regards,
$25 USD in 1 day
4.8 (6 reviews)
3.2
3.2
User Avatar
Recently I have done similar project (Python + Excel), so I can complete this one perfectly. We can do it safely, with preliminary rows marks for deletion and additional logging control, if you want.
$25 USD in 10 days
5.0 (9 reviews)
3.1
3.1
User Avatar
Hello, i have 2+ years experience in excel. I used many formulas, logical and textual function. I know how macros get function, started to learn one month ago. I ould like to give me a chance. I am available to work in any time 10hr per day. Best regards, Andrijana
$21 USD in 1 day
4.8 (8 reviews)
2.9
2.9
User Avatar
Good experience parsing excel and csv files. I prefer working on Python or AWK. A Linux environment is preferred.
$30 USD in 2 days
5.0 (3 reviews)
2.3
2.3
User Avatar
Dynamic macros will be created, with a possibility to change the settings
$25 USD in 1 day
5.0 (1 review)
1.9
1.9
User Avatar
hello. I have worked on excel databases for more than 10 years. I am smart and reliable. I am new to this site and need to gain reviews so I will work for minimum cost. You will stay satisfied. I need to know all the details to tell the exact time. Hope to cooperate with you
$10 USD in 1 day
5.0 (1 review)
1.0
1.0
User Avatar
I am interested and can ensure you for speed and accuracy, just required a quick demo through teamviewer only. I know to use open cart but not much. Thanks. Relevant Skills and Experience Data Entry.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi. I am Rabea. I am read your project and i can do it 100% properly. I have than 2 years experience . Thanku you.....
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, sir! (First Bidder to offer this) I hope I will be awarded from you. ************I agree for any price you will set ** You can test me over chat before you award me! give it a try over chat before you award me! .. you will be %100 satisfied I saw your project and I would like to work on it . I am available 24 hours a day and I have fast response, I will be always there to fulfill your requirement. I always offer low cost and good perfect quality (Just try and see by yourself), I will make you get 100% satisfaction with the best quality service. I will be very happy to work with you, and I hope you too. Thank you
$10 USD in 1 day
5.0 (1 review)
0.0
0.0
User Avatar
Your Satisfaction >>> My Priority! ~ Your Satisfaction Is My Priority, ~ I'll do rework to your Satisfaction. ~ Work 7 days a week and available 24x7. ~ Deliver Projects within the time-frame. My Skills: ~ Data Entry (From Web sites to Web sites, to Software etc) ~ Translation ( English, Arabic, Dutch, Spanish, Portuguese, French etc) ~ Product Uploading(Woocommerce, Amazon, Shopify etc) ~ Professional Writer (Article Writing, Copywriting, Research Work etc) ~ MS Excel (Copy/Paste Data from PDF, Images, Website etc) ~ MS Word (Formatting, Renaming, Conversions, Graphs etc) ~ Customer Care Services ( Experience in Call center field etc) ~ PDF (Conversions to/from MS Office, editing, splitting, forms etc) ~ Data Processing (Retrieve, Transform, or classify information ) ~ Graphic Designing (Remove Background Image etc...) ~ Wed researching ~ Product listings & Promoting Additional Skills: - HTML - CSS - Boot Strap - J Query - WSB - AUctiva - Autocad - Coreldraw - MS Office
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am writing to apply for the position of Virtual Assistant with. I possess four years of experience as a virtual assistant and enjoy the variety of work the job brings each day. As a freelance virtual assistant I currently provide a number of services for my clients including document preparation maintaining files and record keeping. My knowledge of a wide variety of computer programs allows me to easily take on nearly any task I am assigned. I am a quick study and welcome challenges as well. As a detail oriented and organized professional I take pride in completing assignments on time and with accuracy. I can type 100 words per minute and possess excellent communication skills both written and verbal. I would love the opportunity to transfer these skills to your company as your Virtual Assistant. I am a self-starter and have a complete in-home office set up. So I’m ready to begin work as your virtual assistant as soon as possible and welcome you to contact me to set up an interview at your earliest convenience. Thank you so much for your time and consideration. Sincerely, Klarisse Abutal
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BOSNIA AND HERZEGOVINA
Bijeljina, Bosnia and Herzegovina
4.9
81
Payment method verified
Member since May 10, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.