excel - Replace part of string with values in other columns

Question

I am trying to replace a part of string in "input1" with values in column "input2" to get the "output" as shown:

Any idea how to do this in MS excel?

question from:https://stackoverflow.com/questions/65842327/replace-part-of-string-with-values-in-other-columns

Answer 1

Try below formula-

=SUBSTITUTE(A2,"replace_this",B2)