Help With A Power Query

[ColinCowan]

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_Deckler]

@ColinCowan Just how many numbers do you need to replace?

[ColinCowan]

Greg, thanks cira 8 numbers

Colin

[Greg_Deckler]

@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.

[ColinCowan]

Greg I am unsure how to repeat the formula/action more than once.

[Greg_Deckler]

@ColinCowan I wasn't talking about creating a new column. Just right-click the column header of the column in your table. Choose Replace Value... Enter the number to replace and the replacement. Click OK, that will add a step to your query. Right-click the header of that same column again, rinse and repeat. 

[ColinCowan · Accepted solution]

Greg, thanks did not realize that it was that easy

Colin