Forum Discussion

inglexjc's avatar
inglexjc
Post Patron
3 years ago
Solved

Changing Text in Column

How do I change part of the text in a column.  Where ever it shows (LW) in a coulmn I need the text to replace everything in the line and read "Letter Waived".  So in this example  the Table is calle...
  • MAwwad's avatar
    3 years ago

    Go to power query, right click on the column you want to replace values in.

     

    Right click then choose replace values then set values to find = LW and value to replace by is = Legal Files

     

     

    Dont forget to accept this as solution if it helped