Online Course Support | Problem Solving with Excel

Alex received a note that there was an update to some of the data he has been working on. What is the correct formula that Alex should use to substitute the new text for the old?

 
 
 
 
 
 

That’s correct. The format for the substitute formula should start with the text followed by the old text, the new text and ending with the Instance of old text you want to replace.

Similar Posts