2x Small Jobs for Excel Expert, VBA, Find & Replace
$14-30 NZD
Dibayar saat pengiriman
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.
ID Proyek: #37418644
Tentang proyek
57 freelancer rata-rata menawar $24 untuk pekerjaan ini
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 Lebih banyak
Hello, I can help with this job. Can start right now and finish in short time It's easy job for me. I have great experience working with big data sets using VBA. so It's easy. Regarding my experience you can check in m Lebih banyak
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 Lebih banyak
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, I am well-versed in Excel and possess the necessary skills to assist with your specific requirements. Job 1: I will use VBA to create a custom script for finding and replacing words on a list within a workshee Lebih banyak
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 Lebih banyak
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 Lebih banyak
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 Lebih banyak
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 Lebih banyak
Hi, I am a full-time Data Entry Specialist. Your tasks are very simple. There is no need VBA and Macro. Just need a command in Excel. For example: 1. Press Ctrl+F 2. then type "*" in the find search bar and type "X" in Lebih banyak
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 Lebih banyak
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 Lebih banyak
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 Lebih banyak
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 Lebih banyak
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 Lebih banyak
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 Lebih banyak