Tag Archives: Replace Values

Replace values in Power Query

Posted on June 19, 2022 by MF

Find and Replace is quite common in Excel. If you are not sure about what options we have for Find and Replace, please read my blogpost here. In regular Excel, the Find and Replace action is one-off. Whenever we have … Continue reading →

Rate this:

Posted in Power Query | Tagged , | Leave a comment

Do Not input “-” for zero. Use proper formatting in #Excel

Posted on December 5, 2021 by MF

Do you input a hyphen to represent zero? If you do, please stop doing so in the future. The proper way of displaying “-” for zero is to apply relevant cell format to it. E.g. Using Accounting format with no … Continue reading →

Rate this:

Posted in Excel Basic, Excel Tips, Format | Tagged , , , | Leave a comment

How to replace value with a value from another column in Power Query

Posted on September 4, 2021 by MF

It is a common task to replace a value with another value in Power Query. It can be easily done with “Replace Values”. However if you want to replace a value with the corresponding value in another column, it’s not … Continue reading →

Rate this:

Posted in Power Query | Tagged | 6 Comments