2x Small Jobs for Excel Expert, VBA, Find & Replace
$14-30 NZD
Paid on delivery
I am looking for an Excel expert to assist me with two small excel jobs relating to Find & Replace
Job1:
Require to edit a workbook with vba for finding and replacing words on a list on a worksheet.
Job2:
Require formula to find and replace data in a cell where the symbol "*" exists between characters, and replace with a "x"
There should be no spaces between the "*" .. If there is a space then the "*" should not get replaced
Examples:
1*2
A*B*C
12*89*340cm
The size of the box is 53*64*10cm. Good size for shipping
Change to:
1x2
AxBxC
12x89x340cm
The size of the box is 53x64x10cm. Good size for shipping
Requirements:
Column1 return the characters found containing the *
Column2 return all text in cell with the "*" replaced with x
Your SKILLS & EXPERIENCE:
- Proficiency in Excel and familiarity with VLOOKUP and INDEX/MATCH formulas
- Experience in working with specific datasets
- Ability to extract specific data using the formulas
The ideal candidate will have a strong understanding of Excel functions and be able to apply the VLOOKUP and INDEX/MATCH formulas to a specific dataset in order to extract the desired data. This project requires attention to detail and the ability to accurately analyze and extract specific information from the dataset.
Project ID: #37418644
About the project
57 freelancers are bidding on average $24 for this job
Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you. Durai
Hi, I can make a unique formula using VBA programming My SERVICES Automatization Easy and complex formulas Pivot Tables Power Queries Power Pivots + table relationships Custom VBA program + UserForms User data val More
HI Good Day! I am a VBA Macro Developer for 8 years. I know how to do this. Message me anytime to discuss this project. I am confident that I can provide the necessary assistance to enable you to complete your project More
Hi there, I am a Microsoft Certified Professional in Excel and VBA as an Expert. I understood your requirements and it will be delivered in 2 hrs. Awaiting for your reply. Regards, Karthick G.
Hello there myself yesu I am a vba developer I can do this you can contact me on this for further discussion thanks
Greetings, I am an Excel expert with a robust command of VBA and a sound understanding of VLOOKUP, INDEX/MATCH formulas. I am well-equipped to assist with your requirements for Find & Replace tasks in Excel. Utilizing More
VBA script/macro to find and replace list of words in Excel workbook and another one to replace all * in string inside cells with X character, just like you described.
Hello, my name is Basanta Kumar and I am a native of Odisha, India. I have 12+ years of experience in different domains in MNCs like IBM, Accenture, Amazon, and Google. With my extensive knowledge of Excel and its func More
Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply.
Hi there, Good day! I saw your project requiring 2 small jobs to be done in Excel; these are pretty simple tasks I can complete in an hour's time at max. I have a strong background in Excel & spreadsheets as you can s More
Hi there! Looking for a professional Excel Expert, VBA, Find & Replace help Needed? A Microsoft Certified Professional with over 13+ years of experience and hundreds of satisfied clients around the world. I love doing More
Hello, my name is Arpit and I am excited to tell you about our amazing team of experienced professionals who can help with your two small jobs relating to Find & Replace in Excel. We have a deep understanding of Excel More
Hello there! I'm a seasoned clinical research professional with extensive experience in using Excel and Excel formulas. I work with complex formulas like VLOOKUP / XLOOKUP, INDEX, MATCH, OFFSET etc. on regular basis More
Hi there! My name is Kamal a VERIFIED FREELANCER ✅, and I'm a seasoned professional with 9 years of hands-on experience in Microsoft Excel and VBA/Macro programming. I have the necessary skills, expertise, and experien More
Hello, I am interested in your project and i can complete it within required time. I have appropriate experience in Microsoft Office Products(Word, Excel, PowerPoint, Visio, Project as well as VBA etc) of more than 10 More
Hi! My name is Sarah, let me help you. I have strong knowledge in Excel (Formulas, Conditional Formatting and VBA). I did most of my reports (office and personal) through excel for over 10 years. I hope to hear from yo More
Hello! I am Hussain Iftikhar, a developer who has extensive experience in Excel and specifically in using the VLOOKUP and INDEX/MATCH formulas. As you mentioned, you are looking for an Excel expert to assist you with t More