• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power Query Question Excel 2010

M

msquared99

Member
Anyone know how to filter text based on multiple criteria?

I am looking to eliminate any text that begins with C, F, H, N, or T but cannot get the text filter to do this.
 
OK, this is a pain, you have to create a filter for each character that you do not want to use. It seems like it would be much easier to allow for multiple entries.
 
Hi ,

I am not sure what your real requirement is but you can use the Advanced Filter facility.

See the file for an example.

Using VBA will allow you to delete the entries which match.

Narayan
 

Attachments

  • AdvancedFilterExample.xlsx
    15.8 KB · Views: 4
Hi @msquared99.

With file of @NARAYANK991 (¡I'm Glad to share post with you!), you can use a Formula in helper Column, and erase the words with FALSE using a filter.

Please see the file. Blessings!
 

Attachments

  • FilterExample.xlsx
    16.4 KB · Views: 3
Last edited:
You must log in or register to reply here.
Back
Top