I am trying to find a code in power query to replace all occurrences of a value in a text string (Script). The value needing replacing is in "Old Text Value" column. The value I am replacing it with is in "New Text Value". I know this can be done in an excel formula using substitute but looking for a PQ solution. thank you!
Bookmarks