Forum Discussion
Solved
Help With A Power Query
I am a novice with Powery Query, See below formula that works, although I need to continue to replace multiple numbers with "1.5" Regards Colin
Greg, thanks did not realize that it was that easy
Colin
ColinCowan Just how many numbers do you need to replace?
Greg, thanks cira 8 numbers
Colin
ColinCowan I would just right-click your column iwith the numbers in Power Query Editor and do a Replace Values... step. Repeat 7 more times.
Greg I am unsure how to repeat the formula/action more than once.