Find Jobs
Hire Freelancers

Excel, write substitute function for three replacement in the same cell

$10-30 CAD

Opravljeno
Objavljeno pred približno 5 leti

$10-30 CAD

Plačilo ob dostavi
Hi have multiples values to replace by formula, MASTER CARD BECOME MCARD VISA BECOME VISA (WITH A SPACE AT THE END INTERAC BECOME DIRECT actually i tried this function wich return an error: =SUBSTITUE(SUBSTITUE(SUBSTITUE(B5 CARD","MCARD"),"VISA","VISA "),”INTERAC”,”DIRECT”) Need to be there all the time and working on every PC if this file is shared. All need to be in this row cause i want to do a Vlookup IF function after that. The source Row is =sheet1!A1 wich return value example Master card wich need to be replace by MCARD
ID projekta: 18587037

Več o projektu

14 ponudb
Projekt na daljavo
Aktivno pred 5 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
Dodeljeno:
Avatar uporabnika
Hi I am an expert with great skills of data processing, Microsoft Excel, data entry and data management. I have successfully completed lot of tasks here means at freelancer.com. You can view my profile page for my skills, review and feedback of my client I hopefully said that you will be satisfied to award me this job and I promise that I will deliver you a great quality output in timely manners. Your work will be delivered well in advance with seamless communication & timely response until project is completed. As well as for any alternation and query we are available 24 x7. Looking forward for nice start to great future business relations
$14 CAD v 0 dnevu
4,8 (185 ocen)
6,7
6,7
14 freelancerjev je oddalo ponudbo s povprečno vrednostjo $19 CAD za to delo
Avatar uporabnika
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
$30 CAD v 1 dnevu
4,9 (220 ocen)
6,8
6,8
Avatar uporabnika
Hi Sir I have read the your problem statement clearly and will wrote a formula to replace master card,VISA and INTERAC to its repective substitute value which will work across platform Regards
$15 CAD v 1 dnevu
4,9 (341 ocen)
6,4
6,4
Avatar uporabnika
Your formula is close enough to what you want to achieve, it just needs modifications. I can send you the formulas in less than half an hour that will work every time and also with VLOOKUP function. Please send me over the spreadsheet and I'll start right away. Thanks,
$20 CAD v 0 dnevu
4,9 (150 ocen)
6,5
6,5
Avatar uporabnika
hey, can u please share file in in chat in which u want formula ?
$20 CAD v 1 dnevu
4,9 (178 ocen)
6,6
6,6
Avatar uporabnika
Hello, I am Excel and VBA expert. I can do it now (Excel function). If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 80 projects. Jan
$20 CAD v 0 dnevu
5,0 (93 ocen)
6,0
6,0
Avatar uporabnika
Hello. I have rich experiences in Excel and i can do your project in a few mins. I hope to work with you. Thank you.
$20 CAD v 0 dnevu
4,8 (90 ocen)
5,8
5,8
Avatar uporabnika
Hi. I see where is the error and can fix your formula in 5 minutes. If you posted the exact text of your formula. In the other case, it will take a bit more time. Also, I can help you with vlookup and if formulas if you want and can show you the Excel instrument which can help you to find an error in a formula next time. Have a nice day!
$10 CAD v 0 dnevu
5,0 (4 ocen)
5,1
5,1
Avatar uporabnika
I can help you. I have rich experience in excel and VB, and I do my best to save your time and pocket. contact me. MySkills: • Data Management ..............................{Excel, Matlab} • Programming ......................................{Java, C#, VBA, PHP, HTML} • Web designing......................................{Wordpress} • 2D Graphic ...........................................{Photoshop, Macromedia Flash, ...} • 3D Graphic ...........................................{3dsMax, Blender, ...} • Engineering...........................................{AutoCad, Watergem, SewerCad, Flow3D, Elvis, ArcGIS, ...} • Researching .........................................{Green Energy, Solar cells, WaterManagement, ....} Services: ? Accuracy ? Customer satisfaction is my first "Priority" ? Time Commitment ? Availability Thanks, Shahin
$15 CAD v 0 dnevu
5,0 (35 ocen)
4,5
4,5
Avatar uporabnika
Hi, I can turn it around in an hour, Im very familiar with excel look up functions. Anyways, please check your spelling, then if still didnt work, then let’s talk Regards, Reggie
$10 CAD v 1 dnevu
5,0 (2 ocen)
3,6
3,6
Avatar uporabnika
Hi, I am expert in MS Excel, Word, any type of Data Entry Work and Web Research. I am read your project and understood your requirement. I will do Three Replacement in One Row in Excel accurately, timely and within your budget. I am also ready to give you sample work. I am only accept work if you are satisfied with sample work, because your satisfaction is more important for me. Let me know if you have any questions. Regards, Chirag
$10 CAD v 1 dnevu
5,0 (30 ocen)
3,7
3,7
Avatar uporabnika
Hi.. I saw your ad for an excel expert.. I want to work with you on this if you will accept my proposal. Of course I cannot convince you to but I can give an assurance of a good job from me.. Thanks.
$25 CAD v 1 dnevu
5,0 (6 ocen)
2,8
2,8
Avatar uporabnika
Hello? I am a Data scientist with over 5 years experience in using excel and python for web scrapping, data analysis, visualization and modeling. I can provide intuitive excel function and data manipulation skills. I look forward to your response.
$25 CAD v 1 dnevu
3,2 (2 ocen)
1,0
1,0

O stranki

Zastava CANADA
St-hubert, Canada
4,9
20
Plačilna metoda je verificirana
Član(ica) od okt. 9, 2017

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.