Forum Discussion
How to remove text from numbers
Hi Everyone, Hope you can help me with this - I have columns that has mix values (Some cells have text attached to the numbers) as below screen shot. My question is how do I remove the Text attach...
In Power Query Editor, right-click column header. Replace Values. Value to find = MM. Replace with (leave this blank) and then OK, should insert a line like this:
#"Replaced Value" = Table.ReplaceValue(#"Changed Type","MM","",Replacer.ReplaceText,{"Column1"})If you want to make changes to the same column:
Go to edit Queries -> Replace values -> Replace MM with 0 (zero). then you can change the type of the column to "123" or keep it as text as you wish.
If you want to make changes to the same column:
Go to edit Queries -> Replace values -> Replace MM with 0 (zero). then you can change the type of the column to "123" or keep it as text as you wish.