Changing Text in Column

[inglexjc]

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 called "Legal Files" Coulmn is called "Description_1".  Any of the data that shows (LW) needs to replace all the text in that line to say "Letter Waived".

Thank you.

[Karthik12]

Hi 

I hope you can edit column name by double click on the name in visualization part.

Like below

[inglexjc]

I'm not needing to change the name of the Column.

[MAwwad · Accepted solution]

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