Find Jobs
Hire Freelancers

Create a bulk find and replace formula / script for Excel

€30-250 EUR

Completed
Posted about 1 year ago

€30-250 EUR

Paid on delivery
Hi everyone, I am looking for a freelancer who is able to help me to create a bulk find and replace formula or script for Excel. I got an Excel document that contains a lot of keywords. I want to replace them with another value when an exact match has been found. For example: ‘’Cat’’ replace it with ‘’0136’’ It must be able to find and replace thousands of values at once. Colum X should contain the keywords to be found Colum Y should contain the values to replace each value in column X My maximum budget for this task is €50. Looking forward to hearing from you.
Project ID: 36230045

About the project

50 proposals
Remote project
Active 1 yr 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
Awarded to:
User Avatar
Hi i understand that you want a bulk find and replace macro in excel . I can create a code which will scan the keywords in colX and the replacement values in ColY and update the old values with the new one. Ping me in chat to discuss Thanks Vishal
€40 EUR in 2 days
5.0 (82 reviews)
5.1
5.1
50 freelancers are bidding on average €71 EUR for this job
User Avatar
Hello there I will build the tool on python replace the words that you will input I am experienced in web scraping and to build script or a windows desktop application by using python. I am also experienced in large data scraping from the given website, by pass IP, Captcha, and anti bot or cloud flair protection. Please message me to discuss more regarding this project. Best Regards
€50 EUR in 7 days
4.9 (364 reviews)
8.0
8.0
User Avatar
Hello there, I'm George, a professional web crawler expert with a keen eye for automation. After carefully reading your job brief, I'm confident that I'm the right fit for this task. I've been working in the web scalping and developing space for awhile now, and I am well equipped to create a custom script to help you achieve the task at hand. I had the concept that you are looking for already by developing a custom web scrapping tool, which I believe would be the perfect solution to resolving your Excel bulk find and replace. To ensure I am well versed in your exact needs and expectations, could you kindly provide further information on the following: 1. What is the total number of find and replace entries that you need to execute? 2. What type of files / formats will the entries reside in? 3. Are there any specific data formats that the entries need to be in? 4. What is the structure of the input data (i.e. how is the data organised)? 5. Do you need the ability to perform any data manipulation on the entries? I look forward to hearing from you and helping to solve this task. Best, George
€468 EUR in 3 days
5.0 (83 reviews)
7.8
7.8
User Avatar
"""""""""""ADVANCE EXCEL EXPERT/REPLACE FORMULA"""""""""""" """Sir, I will charge 50 euros I can create you this script, it will work with the press of just a button. EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 270+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
€50 EUR in 1 day
4.9 (256 reviews)
7.1
7.1
User Avatar
Hello, I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and macros.
€50 EUR in 1 day
4.9 (128 reviews)
6.6
6.6
User Avatar
Hello Robert, I hope this message finds you well. I will be able to help you with your project. I read through the description and it sounds like I am just the right person for it. I have the right skill set with sophisticated experience in Data Processing, Excel, and Web Scraping. As a next step I would like to discuss some further questions with you. Either over the chat or a call, whatever you prefer. For my references and qualifications: I graduated in Computer Science with highest grades from one of the most reputable universities in Germany. Currently, I am enrolled in the Master's program. During my studies, I already published a paper on the subject of Artificial Intelligence. Further, I managed to get a lot of hands-on experience by working in several companies that operate in the field of Computer Science. As a native German speaker who was living in Canada for a year, my level in English is proficient/fluent. Further, I am in the preferred Freelancer program, making me part of the top 3% on the platform. Many successful past projects can be seen on my profile page. I am looking forward to working with you and if you have any further questions I would be happy to answer them. Best regards, Simon
€200 EUR in 3 days
5.0 (23 reviews)
5.9
5.9
User Avatar
Greetings Thanks for checking my proposal. I would develop script/ formula accordingly for bulk replacement and can start your project immediately. I am full- time freelancer having job experience of more than two decades. It included more than decade of experience as Manager in Public Listed Companies. Having In depth knowledge of Excel for data analysis, Pivot Table and charts, Dashboard, Power query, Macros, User Forms, Advance filters, VBA, Excel Solver, Advance dynamic charts, Financial reporting by using complex Functions. I have also developed many softwares in MS Access. It is my practice to do one project at a time therefore I would assist you full time according to your available time. You can check my scores and reviews Hoping for the positive reply from your side for a long-lasting working relationship. Regards
€50 EUR in 1 day
5.0 (124 reviews)
6.0
6.0
User Avatar
@--uzman burada--@ Hi, there! I have read your description carefully. I can implment your idea as you want. If you work with me, won't be disappointed. please send me a message so that we can discuss about your projects. thanks.
€50 EUR in 3 days
4.7 (23 reviews)
6.0
6.0
User Avatar
Dear client. I am well experienced in excel data processing with PYTHON. I can do your job simply with python. Please ping me to discuss more. Regards.
€50 EUR in 1 day
5.0 (18 reviews)
5.2
5.2
User Avatar
Hi I can help to do this job and can start right now. Can do within very short time. Have finished few like this job already. My solution will do it all very fast Regarding my experience you can check my 100% feedback and reviews I have 16+ year experience of Excel, Excel VBA and Have 100% feedback So, you can trust me. Result will be as you need Best Regards
€35 EUR in 1 day
5.0 (66 reviews)
5.3
5.3
User Avatar
Hello, I can create a macro to find a replace values, according to your requirements. I am a VBA Developer with extensive experience in task automation in Excel, and I can quickly and easily deliver the results you need. Please feel free to contact me to discuss your project in detail. Thank you a lot. Best regards, Emilia
€35 EUR in 1 day
5.0 (24 reviews)
4.8
4.8
User Avatar
Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how many hours it will take to fulfill the work. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein
€50 EUR in 7 days
5.0 (22 reviews)
4.8
4.8
User Avatar
Ready to start ASAP. I have more than 6+ years experience in DATA ENTRY, EXCEL MACRO & EXCEL VBA. I can make you the very best work completion with 100% accuracy in said time. Am fast and reliable who will complete in your budget.
€30 EUR in 1 day
4.9 (39 reviews)
4.6
4.6
User Avatar
Hello! I am confident that I am the perfect candidate for this job, hence I would like to submit my proposal for your consideration. I have rich experience in Visual Basic, Web Scraping, Data Entry, Data Processing and Excel. In the two years I've been freelancing, I have written countless projects related to yours. I am confident that I can produce high-quality work for you. My rates are very reasonable, and I am available to start immediately. If you would like to see some of my previous work, I can provide you with a portfolio of my writing samples. I'm sure that you will be impressed with the quality of my work, and I look forward to hearing from you soon. Thank you for your time Carolyne
€155 EUR in 1 day
5.0 (1 review)
4.1
4.1
User Avatar
Dear Sir, I have carefully reviewed your instructions and I am confident that I can complete this project efficiently. I would appreciate the opportunity to work on this project, and I assure you that I will deliver high-quality work with unlimited revisions. Moreover, I am committed to working on your project even after the work is completed. Please let me know if you have any questions or concerns. I look forward to your response. Thank you for your time. Best regards, UMAIR
€40 EUR in 1 day
5.0 (47 reviews)
4.1
4.1
User Avatar
Hi, Greetings I have. 5+ years of experience related to MS Office. The project you have posted '' Finde and replace'' the project is related to excel automation that is quite easy for me. I am interested to work on the project you have posted. I will do the job with 100% accuracy and will complete within time period. I want to start right now. please feel free to discuss further in the chat section. Thanks M Ishaq
€30 EUR in 2 days
5.0 (2 reviews)
3.7
3.7
User Avatar
Hi, Good day. I can help you create a replace formula for keywords in your Excel file. I am available to start anytime. I have been using Excel for more than 10 years and I know how to make a formula for this requirement. I am very confident that I will be able to provide you with the best quality of output possible. I hope to hear from you soon. Thank you and best regards!
€30 EUR in 2 days
5.0 (5 reviews)
3.4
3.4
User Avatar
Hello, I believe I can help you with this simple task. I can develop a utility script that implements this workflow for you, the utility script will read a pre-configured file that has 2 columns: 1# first one is the original column and all words are to be replaced. 2# second one is the second column that has the values that replace the first column. This way, the 2 columns and list of words will be dynamic and can be altered anytime you like. I look forward to hearing from you to discuss this further.
€30 EUR in 1 day
5.0 (9 reviews)
3.4
3.4
User Avatar
Hi, I checked your requirement, i have Experience in below technical work. Power Bi Desktop & Services With DAX, Power Editor, Excel VBA, Power Query, Power Pivot, Advance Excel, Excel Dashboard dynamically with VBA Codes. Knowledge About Json file, SQL, MS Access with VBA etc. For More Details Check my Portfolio's Sample Work. With Best Regards, Data Analyst/Power bi Specilist
€50 EUR in 1 day
5.0 (3 reviews)
2.5
2.5
User Avatar
Hi there! I just read your job description and I see that you are looking for a freelancer who is able to help you to create a bulk find and replace formula or script for Excel. I will help you with this task. I am able to transform all your ideas into reality. You will be working with an expert who knows what he is talking about, is trustable, honest, hardworking, skillful, and knows how to achieve your goals altogether. Please message me and I will share my portfolio. For further details, please visit my profile at https://www.freelancer.com/u/razmanf I have had repeat clients for several projects on Upwork and here are some of the testimonials: - Quick PowerPoint Help Graphics (5.00/5.00) "EXCELLENT AND PROFESSIONAL FREELANCER, thank you I will continue to work with this freelancer on all my future projects. great communication, skills and professionalism." - Rafael Baqueiro I pride myself on offering rapid turnarounds and quality projects to my clients. And I would like to do the same for you. Shoot me a quick message here on Freelancer today for further details on this project! Best regards, Razman
€35 EUR in 7 days
5.0 (5 reviews)
1.0
1.0
User Avatar
Hi! I am fluent in Excel and work with formulas. Ready to do it quickly and efficiently. To demonstrate my professionalism, I am ready to replace 2 variables in test mode. Send me a file. What do you say to that? P.S. And, of course, I will ask for feedback. Thank you! Victoria Nedbaeva
€50 EUR in 3 days
5.0 (1 review)
0.3
0.3

About the client

Flag of NETHERLANDS
Amsterdam, Netherlands
5.0
109
Payment method verified
Member since May 8, 2016

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.