Understand how to replace part of a text string with another string using the REPLACE formula.