Trick 010 Replace multiple characters in excel table with power query

     To replace characters in excel, we also have many ways to do this such as: using SUBSTITUTE, REPLACE, VBA ... But when you need to replace many characters or values at the same time. When we use common functions in excel, we have to do it many times.

  Today's article I introduce to you another way to replace multiple characters that is using power query.

  The benefit of using power query is that it only needs to be done once, not as heavy on the spreadsheet as using a regular excel function, highly customizable.

  Here is an example to do this.

We have a data table like this

Link to download excel file.