News

This changes/replaces only the first occurrence of the Old Text to New Text. 5. Next, enter this formula in the remaining cells (in our case, D8 through D13): =SUBSTITUTE(A2, B2,C2).