What is the difference between replace and substitute in Excel?
The differences between the two functions are as follows: SUBSTITUTE replaces one or more instances of a given character or a text string. ... REPLACE changes characters in a specified position of a text string. So, if you know the position of the character(s) to be replaced, use the Excel REPLACE function.
What is the difference between replace by and replace with?
If you are referring to replacing something that is broken, old, or not working/inoperative, then you replace it with a new one. If you are referring to filling the role of someone or something with a substitute, then it is 'replaced by'. "Human bank tellers have all but been replaced by ATMs."