Exclude all numerical data in query

[Anonymous]

HI all, i wish to filter out all numerical values in the query - how can I do that? 

e.g., filter out 123123, 234234, 23312 and keep only the text character abgh, sjgfn, sdjf

THANKs!!!

[v-angzheng-msft · Accepted solution]

Hi,@Anonymous 

Try to use Text.Select or Text.Remove to add a new column in PowerQuery. These two functions have their own advantages and disadvantages. Choose the function that you need.

For references:

Text.Remove 

Text.Select 

Hope this helps

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , refer this blog, do reverse of it to keep text

https://eriksvensen.wordpress.com/2018/03/06/extraction-of-number-or-text-from-a-column-with-both-text-and-number-powerquery-powerbi/