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
17 freelancers are bidding on average $20 for this job
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
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
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.
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