Excel Tips - Tip 26 (Using SUBSTITUTE Formulae)

Hello,

Hope my excel tips are helping you out.

Here is Today’s tip for you. Hope this help you.

If ever we want to replace a text with other text , then use Substitute Command to replace the same.

What Does It Do ?

·         This function replaces a specified piece of text with a different piece of text.

·         It can either replace all occurrences of the text, or a specific instance.

·         The function is case sensitive.

How to use it ?

'=SUBSTITUTE(OriginalText,TextToRemove,TextToInsert,InstanceToUse)

For example, please check the images.

Hope the Tip is found interesting to you and the same is clear.

Looking forward for a feedback.

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/alreadyresponded?c=0&w=1

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Thanks & Regards,

CA Mohit Bansal

Excel Enthusiast

+91-9045773456