ashley1984
New Member
- Joined
- Mar 31, 2018
- Messages
- 32
- Office Version
- 365
- Platform
- Windows
I have a table in Excel power query with text in a number of cells that I want to replace with new text.
E.g in the cells I might have 2 for x or save %. I want to replace the 2 for x with the word “multi-buy” or the save x% with “Price Reduction”. I want to find the cell value to replaced based on the middle text, so in this case look up “for” and then replace the cell text with “multi-buy”
E.g in the cells I might have 2 for x or save %. I want to replace the 2 for x with the word “multi-buy” or the save x% with “Price Reduction”. I want to find the cell value to replaced based on the middle text, so in this case look up “for” and then replace the cell text with “multi-buy”
