CODEWITHSUNDEEP
excelexcel-formulapowerquery
GAURAV SEMWL
GAURAV SEMWL

Reputation: 27

How to modify column in power query

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

enter image description here

Upvotes: 0

Views: 986

Answers (1)

Peter
Peter

Reputation: 12325

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.

Upvotes: 1

Related Questions