Hello friends,
today we will talk about Substitute function in Excel. Basically when we use substitute in excel it means totally substitute or change old one text to a new one text, it replace the mentioned text with the new one.
The example is mentioned below as you are seeing that cell A1 has Narentra in cell B1 has (t) and cell C1 has (d), here in this formula we have to substitute (t) from alphabet (d) and the name will become Narendra instead of Narentra.
So the substitute role is to change or replace the desired word from existing word.
today we will talk about Substitute function in Excel. Basically when we use substitute in excel it means totally substitute or change old one text to a new one text, it replace the mentioned text with the new one.
The example is mentioned below as you are seeing that cell A1 has Narentra in cell B1 has (t) and cell C1 has (d), here in this formula we have to substitute (t) from alphabet (d) and the name will become Narendra instead of Narentra.
So the substitute role is to change or replace the desired word from existing word.
Hope that you will come to know the function.
Have a good day.
Narendra
No comments:
Post a Comment