Dynamic Replace

[mstoler]

Hello,

I need to replace a value in my input column with a lookup.

In this example I need to replace "Michael Smith was here" and change the Smith to Johnson.  It should then read "Michael Johnson was here"

Is there a way to do this dynamically?

Thank You,

Michael

[mstoler · Accepted solution]

Hello,

I figured it out.  Simply Find and Replace tool.