How to replace words in excel? Substitute or replace in excel?

How to replace words in excel

How to replace words in excel? You can use two different functions – substitute and replace. Difference between substitute and replace are shown from the following table. SUBSTITUTE function in excel The substitute function in excel is to replace a text within a cell by a new text Syntax SUBSTITUTE(text,old_text_new_text,[Instance_num]) Argument Argument Description text The … Read more