SUBSTITUTES formula substitutes existing text with the new specified text in text string
Live Example here:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Exactly what I needed still relevant in 2021 Thank you!
In MS-Excel, How can I Change as follows (automatically)-
1 into 6, 2 into 7, 3 into 8, 4 into 9, 5 into 0, 6 into 1, 7 into 2, 8 into 3, 9 into 4, 0 into 5.
As I type 248 in a cell, I would get 793 as result in another cell,
As I type 806 in a cell, I would get 351 as result in another cell,
As I type 100 in a cell, I would get 655 as result in another cell.
What if i want to substitute a with 1 and b with 2 and so on ?? Can you help me with i should use then
great video! thanks for making ans sharing 😉
subscribed!
Holy cow Dude, this is increible – adding this to nested substitute is what I needed, !
e.g.
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"_AB","_"),"_CD","_"),"_EF","_")
TQ. Nice
Trump lol
nice
Hello Summit,
I have faced one problem in relates to this substitute function and example is AssAdeAcs like this now i want only substitute 1st two A A after this the word would look like CssZdeAcs but how i could not find the proper function to replace only two times AA not 3 times A..Could you please help me.
I have an excel data sheet in which there are more than 1000 words – Column A with old text and Column B with new text. Company provides me a paragraph where I have to replace old text with new text. Multiple substitutes can’t be used if it exceeds the limit. Is there a way out?
How about if I want to give excel two different characters to be substituted by new charters?