Find Jobs
Hire Freelancers

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

$10-30 CAD

Completed
Posted over 5 years ago

$10-30 CAD

Paid on delivery
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
Project ID: 18587037

About the project

14 proposals
Remote project
Active 5 yrs 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 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 in 0 day
4.8 (185 reviews)
6.7
6.7
14 freelancers are bidding on average $19 CAD for this job
User Avatar
"""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 in 1 day
4.9 (220 reviews)
6.8
6.8
User Avatar
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 in 1 day
4.9 (341 reviews)
6.4
6.4
User Avatar
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 in 0 day
4.9 (150 reviews)
6.5
6.5
User Avatar
hey, can u please share file in in chat in which u want formula ?
$20 CAD in 1 day
4.9 (178 reviews)
6.6
6.6
User Avatar
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 in 0 day
5.0 (93 reviews)
6.0
6.0
User Avatar
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 in 0 day
4.8 (90 reviews)
5.8
5.8
User Avatar
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 in 0 day
5.0 (4 reviews)
5.1
5.1
User Avatar
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 in 0 day
5.0 (35 reviews)
4.5
4.5
User Avatar
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 in 1 day
5.0 (2 reviews)
3.6
3.6
User Avatar
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 in 1 day
5.0 (30 reviews)
3.7
3.7
User Avatar
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 in 1 day
5.0 (6 reviews)
2.8
2.8
User Avatar
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 in 1 day
3.2 (2 reviews)
1.0
1.0

About the client

Flag of CANADA
St-hubert, Canada
4.9
20
Payment method verified
Member since Oct 9, 2017

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.