Forum Discussion

Alex_'s avatar
Alex_
Frequent Visitor
5 years ago
Solved

If cell is number then cell, else empty

Hi! I have some data like the following:   % 25 15 Some text Words typed 75   I need to work with just the numbers in the column. How can I delete the text data without remov...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    Alex_ 

    You are better off doing the transformation in powerquery I think.  It is 3 steps to get to what you are looking for.

    • Duplicate your column
    • Convert the new column to decimal data type (this will make all text values error)
    • Replace errors with null.

    I have attached my sample book for you to look at.  Right click on the table and go to Edit Query to see the steps.

     

Alex_'s avatar
Alex_
Frequent Visitor
5 years ago

Hi amitchandak

 

Thanks for your help! Unfortunately this doesn't work as there are some dates mentioned within the text. I need to show the value if there is only numbers, and nothing if there is a mix.