Expression error when trying to use TEXT.SELECT

[abaker77]

Using Power Query, I have a column of numbers for most rows, but some rows contain text characters along with the number itself; I'm trying to remove those characters to leave just the numbers.
I create a custom column and used the TEXT.SELECT statement but got the error.
Screen print is attached.

Any help is greatly appreciated.
Thank you !

 

[JGordon11]

Your Sales amt column data type in the image is any, see the ABC123 icon (not text ABC). PQ is interpreting the numbers in that any type column as type number (right aligned) and Text.Select requires data type text. If you want to keep the any type you would need to do something like:

= Text.Select(Text.From([Sales amt], {"0".."9"})

But since you probably want the output as number, wrap that in Number.From

= Number.From(Text.Select(Text.From([Sales amt], {"0".."9"}))

 

[abaker77]

You're RIGHT - the data type was the problem. Your solution is great - THANK YOU SO MUCH.