Excel Substitute and Replace

Maybe I knew this and had to relearn it, but was momentarily stumped when I needed to do some quick clean up and started to use the replace function. The syntax for it seemed strange:




Turns out what I needed was Substitute. Here’s what the help page says:

Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string

And here is what it looks like:




I’m sure there is a reason for it, but it sure seems like a strange implementation