Remove rows of text using PowerQuery?

[nobodyukno]

So I have not really used PowerQuery in the past. I have a data set with thousands of rows of numbers. Some of these numbers are actually text (1S432490). I know I could probably use a macro to remove the rows of text, but I kind of want to stay within PowerQuery if there is a way to remove these rows of text.

The reason I am asking this is because I want to create a filter between two values within PowerQuery, but it's giving me some error about format, and then when I manually go into my table and remove those rows that contain text, my filter then works.

Thanks for the help.

[jeffreybrown]

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.