I love the way Excel functions, like SUBSTITUTE, can save you time. If you are not familiar with this function, use SUBSTITUTE when you want to replace specific text in a text string. Let’s see how with the example below. I want to substitute “Cost” for “Sales” and use the formula highlighted on the Formula bar.
Can you think of any examples where you could use this? Companies often change their names so this function can be used to change Suntrust Bank to Truist Bank with minimal effort.
Contact me at firstname.lastname@example.org for support on using the SUBSTITUTE function. Need help with Excel - coaching, data analysis and/or training? Contact me at 561-289-9484 to discuss your needs.