top of page

Using excel's substitute function

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 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.

Recent Posts

See All


bottom of page