Question: what is the difference between replace and substitute in excel?
Answer: 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.