Forum Discussion

lastnn30's avatar
lastnn30
Post Patron
3 years ago
Solved

spliting numbers

Hi

I got list of tallest building from the link below. One table has Height column and the numbers are like this

 

100.3 m

200m

300 m

400.1m

 

How to get rid of m? I used Power Query-->Split-->Delimiter , first using Space and I got rid of some m but for numbers like this

 

200m

 

I can use Split--> From Digit to Non Digit, but for number like this

 

400.1m

 

If I used Split-->Digit to non Digit, I will get this

 

400      .1     m

 

But I want to split like this   400.1   m

 

What you would do? Thank you so much.

 

https://en.wikipedia.org/wiki/List_of_tallest_buildings

2 Replies