spliting numbers

[lastnn30]

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

[Greg_Deckler · Accepted solution]

@lastnn30 In Power Query use a Replace to replace "m" with "" (nothing) and then do Trim and Clean operations.

[tackytechtom · Accepted solution]

Hi @lastnn30 ,

How about this:

Before:

After:

Just right click onto the column and press Replace Values...:

Chose "m" for Value to Find and leave Replace With empty:

Finally, change Data Type to Decimal Number:

Was this what you were after? Let me know 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Greg_Deckler · Accepted solution]

@lastnn30 In Power Query use a Replace to replace "m" with "" (nothing) and then do Trim and Clean operations.