Forum Discussion
Solved
Convert to Numeric value from string. VALUE AND FORMAT FUNCTION NOT WORKING
Hi I wanted to know if there was a way to extract a number from a text value. This is how the data is being cleaned in and I want to use this as integers, but it is reading it as a string. Any i...
You can replace Mbps with empty string in Query Editor and convert the result column into number.
See tutorial here: https://support.office.com/en-us/article/replace-values-power-query-28256517-f1e9-4dc3-832f-45786e9cf721.
Enter Mbps in Value to Find field and leave Replace With blank
How exactly do I do that?
See tutorial here: https://support.office.com/en-us/article/replace-values-power-query-28256517-f1e9-4dc3-832f-45786e9cf721.
Enter Mbps in Value to Find field and leave Replace With blank