Question: what is the replace formula in excel?
Answer: Excel REPLACE Function. The Excel REPLACE function replaces characters specified by location in a given text string with another text string. For example =REPLACE("XYZ123",4,3,"456") returns "XYZ456". The altered text.