Excel "SUBSTITUTE" Function

Hi Steemit,

I just wanted to share some excel stuff - SUBSTITUTE function. What is it?

The Excel SUBSTITUTE function replaces a text in a given string or text. For example:

![Capture5.PNG](

The original text is "Steemit is a social media platform where everyone gets paid for creating and curating content." Now, with the help of the SUBSTITUTE function, we were able to replaced the e's with  "*". Let's break it down.

The syntax is -  =SUBSTITUTE (text, old_text, new_text, [instance]) . We can see that there are 4 arguments.

• text - The text to change.
• old_text - The text to replace.
• new_text - The text to replace with.
• instance - [optional] The instance of old_text to replace with new_text. Optional; if not supplied, all instances of old_text are replaced with new_text.

In our example we used =SUBSTITUTE(B2,"e","*"). 

• text -  Steemit is a social media platform where everyone gets paid for creating and curating content. (located in cell B2)
• old_text - all letter "e" in our text. (to be replaced with new_text)
• new_text -  our new text is "*". (will replace old_text)

So, I believe that would be all for now. I hope I've shared some useful information to Steemit community :)

Looking forward for more story :)

Thanks!