locked
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.

    "Trust"

    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.

    Thanks,

    Quentin


    QHarri

    Thursday, April 13, 2017 3:01 PM

Answers

  • 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