Home > front end >  How to modify column in power query
How to modify column in power query

Time:11-09

How can I remove comma from the cell in column 33 and 23 in power query?

enter image description here

CodePudding user response:

In the Transform section above the formula bar you see the Replace Values function. You can use the function to replace "," with "". That's it.

But after removing the first 2 rows and promoting the 3rd row as headers you can directly convert 33 and 23 into decimal numbers and a thousands or decimal separator would be recognized depending on your regional settings.

  • Related