How can I remove comma from the cell in column 33 and 23 in power query?
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.