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!