Forum Discussion
Solved
How to Replace Number Values with Text
I have about a dozen columns with lots of rows all with various numbers in them as well as other non-numerical data. I would like to use Power Query to replace all of those number values with "$$$" ...
NewStep=Table.ReplaceValue(PreviousStepName,"","",(x,y,z)=>Text.Combine(Text.SplitAny(Text.From(x),"0123456789"),"$"),Table.ColumnNames(PreviousStepName))
NewStep=Table.ReplaceValue(PreviousStepName,"","",(x,y,z)=>Text.Combine(Text.SplitAny(Text.From(x),"0123456789"),"$"),Table.ColumnNames(PreviousStepName))
Thanks for the help! I'm still learning, do you think you could add a bit of an explainer?