Find Jobs
Hire Freelancers

Have to clean and Excel FIle

$2-8 USD / hour

Closed
Posted over 6 years ago

$2-8 USD / hour

I have attached sample. Column c is "Before Editing" and column d is "After Editing".So you have to make formula for column c to clean everything.I just need the number from column c. First one is complete sample check and let me know you can do it or not.I will you pay 5$ for this simple task.
Project ID: 15708687

About the project

48 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
48 freelancers are bidding on average $5 USD/hour for this job
User Avatar
I have created a function that can be called from the column D to extract the auto parts number. I have tested in the other rows and it's working fine. Result for row3: 1520379, 1520390, 1520395, 1520478, 1520505, DW57120, 10302760, 10303700, 10303701, 10101200, 11101200, 12101200, 6511439, 618120, 4718142, 2UZ19V703, 5U2Z19V703KA, F2UZ19V703, F2UZ19V703FA, 57120, 58120, 6511439, 7511439, 5473, YCC197, 253161, 273136, TEM253161, TEM273136, 2010583, 2010583AM, 57120, 010302NEW, 10302, 142735, 142735C, 142735NC, 142735NEW, 2067, 2067N, 6001279, C388, C388R, 10000502, 10000511, 000079, 001016, 010001, 010394,
$4 USD in 40 days
5.0 (56 reviews)
6.4
6.4
User Avatar
I have a lot of practical experience in Excel, including programming in VBA. Your task is clear to me and I am ready to execute the project for 5 USD for 1 hr.
$5 USD in 1 day
4.9 (116 reviews)
6.4
6.4
User Avatar
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating Strings. So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
$5 USD in 40 days
4.8 (127 reviews)
6.1
6.1
User Avatar
Hello, I have prepared excel macro which will format data as required. Please send few sample records. I will format them and if you are satisfied we can proceed ahead. Looking forward to your reply. Regards, Aditya
$5 USD in 1 day
5.0 (257 reviews)
5.9
5.9
User Avatar
Hello, I have gone through your project description and I'm very much interested in doing your project. I'm sure I will exceed your expectation. Thank you for your consideration. Regards.
$5 USD in 40 days
5.0 (53 reviews)
5.6
5.6
User Avatar
Hello I saw your project and I understand and I can do this because I have good experience about this and if you give me your project then I will give your good quality work
$5 USD in 40 days
4.9 (22 reviews)
4.6
4.6
User Avatar
Hi, I think I can do it.... My Question is, would it be only 5 records? It can be done manually or with macro VBA formula, its up to you which you like.
$4 USD in 40 days
5.0 (47 reviews)
4.7
4.7
User Avatar
I have good experience in excel. I have gone through the sample file and calculation needed for the task. I am comfortable to complete the task within the time limit.
$5 USD in 40 days
4.8 (35 reviews)
4.9
4.9
User Avatar
Hi, We could create a nice macro that will process this data instantly and I will also explain to you how I did if you want. My last VBA work includes: - tool that automatically prepares PDF invoices using complex calculations - tool that send emails automatically for each team leader containing only his team members+custom attachment - import of one excel file within another in order to be processed following some configurable parameters - vba tools with multiple forms, transfer data between windows forms - data processing and reconciliation I look forward bring value and automate some tasks. Cheers! Marius
$5 USD in 40 days
5.0 (28 reviews)
4.4
4.4
User Avatar
I can easily do this task in a few minutes. I created 2 formulas and I was able to retrieve the data as you required it in the sample. I can share with you, please contact me through chat.
$5 USD in 1 day
4.9 (12 reviews)
4.3
4.3
User Avatar
expert in excel. i can comolete ur task
$2 USD in 4 days
4.3 (20 reviews)
4.1
4.1
User Avatar
A proposal has not yet been provided
$5 USD in 1 day
5.0 (6 reviews)
3.0
3.0
User Avatar
Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss. I have more then 5 years experience of advance excel such as lookups, pivots, macros, vbscripts etc. I have the relevant skills and experience to complete your work in given time frame.
$2 USD in 40 days
4.3 (14 reviews)
3.6
3.6
User Avatar
I have seen the example. I have experience in excel. I assure you to do the task on time with accuracy. I took your sample and i have made some changes you required. i can show you in inbox
$5 USD in 40 days
5.0 (1 review)
2.5
2.5
User Avatar
Hi there, you will need my expertise on this data cleansing. I can deliver the job fast and accurate. Thank you.
$5 USD in 5 days
5.0 (6 reviews)
2.1
2.1
User Avatar
Hey there. Asides my technical competency with excel that I have gathered for over 3 years, I have quite the communication skills that would put your mind during the entirety of the project timeline. I also offer standard and perfect work that would guarantee quality. Please consider my bid. Thank you, Cheers!
$5 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I complete my work as per your given time limits
$5 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$5 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will make it very quick for you with very reasonable price. Worked in excel for long time to perform such tasks in a timely manner with 0% mistakes
$2 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Hiring Manager, I have gone through your job requirement and I understand that it requires a high speed typing skill with 100% accuracy. I have 1+ years of experience working with Ms Excel and MS Office tools Transcription. I have been doing administrative work like typing material from one source to other for long time as free lancer. I am having excellent typing speed with 100% accuracy. I understand the how critical is the project. I would like to be a part of this to with all my experience on admin work. I am new to freelancer.com platform but I have been associated as freelancer for more than 1 years and working Admin work with high efficiency. Please let me know when can we discuss further on this project to have better understanding of the requirements. Thanks and Regards, shahrukh khan MS Excel Expert | Admit Job Expert less and Transcription
$5 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BANGLADESH
,JESSORE, Bangladesh
4.9
258
Payment method verified
Member since Nov 9, 2013

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.