cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amahmud Member
Member

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 attached with the numbers and I just want to keep the numbers (Basically just want to remove all the MM as shown in the picture below)- 

Remove Text from Number.JPG

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: How to remove text from numbers

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"})

I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Akshaya Established Member
Established Member

Re: How to remove text from numbers

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. 

Replace_1.pngReplace_2.png

 

View solution in original post

3 REPLIES 3
Super User
Super User

Re: How to remove text from numbers

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"})

I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Akshaya Established Member
Established Member

Re: How to remove text from numbers

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. 

Replace_1.pngReplace_2.png

 

View solution in original post

amahmud Member
Member

Re: How to remove text from numbers

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 404 members 3,763 guests
Please welcome our newest community members: