Completed

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

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

Skills: Excel

See more: excel macro move data existing cell, excel visual basic function howto, excel vba input function, find and replace cell reference in excel formula, excel substitute multiple, excel substitute multiple characters, excel replace wildcard, how to replace text of a cell based on condition in excel, excel replace character in cell, excel substitute wildcard, excel substitute array, using excel write mysql, excel macro cut paste based cell value, excel 2003 macros copying next cell, excel macro counting phrases within cell, excel zip radius function, write javascript function mysql query, vba excel write file, excel macro sort function, excel write custom xml

About the Employer:
( 14 reviews ) St-hubert, Canada

Project ID: #18587037

Awarded to:

datakillers

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 ski More

$14 CAD in 0 days
(80 Reviews)
5.8

17 freelancers are bidding on average $20 for this job

Tanmoy236

"""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 m More

$30 CAD in 1 day
(184 Reviews)
6.7
rohitagarberg

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
(284 Reviews)
6.3
zolayossa

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 ov More

$20 CAD in 0 days
(140 Reviews)
6.3
bilalmaher053

hey, can u please share file in in chat in which u want formula ?

$20 CAD in 1 day
(150 Reviews)
6.1
macroPOL

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. More

$20 CAD in 0 days
(78 Reviews)
5.8
aubrey03

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]

$30 CAD in 1 day
(65 Reviews)
5.3
lightingdavid

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 days
(17 Reviews)
4.9
capatel341

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 with More

$10 CAD in 1 day
(27 Reviews)
3.7
hopkovictoria

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 yo More

$10 CAD in 0 days
(3 Reviews)
3.1
Karicke

I have extensive excel knowledge and will be able to help you with the formula you are struggling with in a short time frame

$14 CAD in 0 days
(5 Reviews)
2.1
suchita29a

Hello, I can help you with the work for finding the error. I have experience in Excel VBA Thanks & Regards, Suchita

$25 CAD in 1 day
(3 Reviews)
1.4
sharifemran420

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
(1 Review)
1.1
IgeS

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
(1 Review)
1.0
cliffstats

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 More

$25 CAD in 1 day
(1 Review)
0.5
shahinrahimi

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 ........ More

$15 CAD in 0 days
(1 Review)
0.4
redmapple3

hi dear. your idea is interesting for me. please contact me then we can discuss more detail via chat, thanks., regards.

$35 CAD in 1 day
(0 Reviews)
0.0