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-...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

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

tackytechtom's avatar
tackytechtom
Most Valuable Professional
3 years ago

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/