Replace & Substitute formula in Excel || How to write & difference of Replace & Substitute function
👉 The Excel REPLACE function replaces characters specified by location in a given text string with another text string.
👉The Excel SUBSTITUTE function replaces text in a given string by matching.
👉SUBSTITUTE function finds the particular text and replaces it whereas REPLACE function replaces the text defined by its position.
Syntex
=REPLACE (old_text, start_num, num_chars, new_text)
=SUBSTITUTE (text, old_text, new_text, [instance])
============================================================
Sharing is caring !!! Your responses will inspire me to upload more tutorial.💪💪
So...Share 🤝 || Like 👍 || Comment ✍️
• Our all youtube video:- https://www.youtube.com/c/mmbcampus?s...
• Excel VBA all video:- • How to use "IF, ElseIf, Else" in Exce...
• Excel Formula all video:- • How to write Microsoft Excel Formula,...
• Ask your any question in facebook page / mmbcampus2016
• Visit https://www.mmbcampus.com to download all related file, if any.
====================================================================