Find Jobs
Hire Freelancers

Have to clean and Excel FIle

$2-8 USD / hour

Fermé
Publié il y a plus de 6 ans

$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.
N° de projet : 15708687

Concernant le projet

48 propositions
Projet à distance
Actif à il y a 6 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
48 freelances proposent en moyenne $5 USD/heure pour ce travail
Avatar de l'utilisateur
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 en 40 jours
5,0 (56 commentaires)
6,4
6,4
Avatar de l'utilisateur
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 en 1 jour
4,9 (116 commentaires)
6,4
6,4
Avatar de l'utilisateur
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 en 40 jours
4,8 (127 commentaires)
6,1
6,1
Avatar de l'utilisateur
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 en 1 jour
5,0 (257 commentaires)
5,9
5,9
Avatar de l'utilisateur
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 en 40 jours
5,0 (53 commentaires)
5,6
5,6
Avatar de l'utilisateur
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 en 40 jours
4,9 (22 commentaires)
4,6
4,6
Avatar de l'utilisateur
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 en 40 jours
5,0 (47 commentaires)
4,7
4,7
Avatar de l'utilisateur
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 en 40 jours
4,8 (35 commentaires)
4,9
4,9
Avatar de l'utilisateur
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 en 40 jours
5,0 (28 commentaires)
4,4
4,4
Avatar de l'utilisateur
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 en 1 jour
4,9 (12 commentaires)
4,3
4,3
Avatar de l'utilisateur
expert in excel. i can comolete ur task
$2 USD en 4 jours
4,3 (20 commentaires)
4,1
4,1
Avatar de l'utilisateur
A proposal has not yet been provided
$5 USD en 1 jour
5,0 (6 commentaires)
3,0
3,0
Avatar de l'utilisateur
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 en 40 jours
4,3 (14 commentaires)
3,6
3,6
Avatar de l'utilisateur
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 en 40 jours
5,0 (1 commentaire)
2,5
2,5
Avatar de l'utilisateur
Hi there, you will need my expertise on this data cleansing. I can deliver the job fast and accurate. Thank you.
$5 USD en 5 jours
5,0 (6 commentaires)
2,1
2,1
Avatar de l'utilisateur
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 en 40 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I complete my work as per your given time limits
$5 USD en 10 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
A proposal has not yet been provided
$5 USD en 10 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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 en 40 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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 en 5 jours
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de BANGLADESH
,JESSORE, Bangladesh
4,9
258
Méthode de paiement vérifiée
Membre depuis nov. 9, 2013

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.