How to find and replace a string in a cell that is also present as a substring in another cell RRS feed

  • Question

  • Hi,

    I want to use Powerquery to place a string in a column e.g.


    However, "Trust" was renamed to "Trust New" at a certain point in time. Is it possible to replace "Trust" with "Trust New" only where the text is "Trust" and not also is existing "Trust New" strings. I don't want to end up "Trust New Trust New". Although i could do a replace on that.




    Thursday, April 13, 2017 3:01 PM


  • My suggestion would be to first replace "Trust New" with "Trust" and next replace "Trust" with "Trust New".
    Thursday, April 13, 2017 3:40 PM