[Affiliate]
Blog Stats
- 3,291,002 hits
-
Join 3,246 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Show number in thousand (k) or in million (M) by using custom format
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- The INDIRECT trick of using Structured Reference in Conditional Formatting
- Perform VLOOKUP with 2 lookup values
- SUM vs. SUBTOTAL
- #Excel Add current selection to filter. What it does?
- How to replace value with a value from another column in Power Query
- Rename column names in a dynamic way with #Excel #PowerQuery
- Open an embedded Excel file during a slide show in PowerPoint?
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Replace Values
Replace values in Power Query
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
Do Not input “-” for zero. Use proper formatting in #Excel
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
Posted in Excel Basic, Excel Tips, Format
Tagged Custom Format, Format, Power Query, Replace Values
Leave a comment
How to replace value with a value from another column in Power Query
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
wmfexcel 