Simple Filter - starts with "1-6"

2 followers
0
Avatar

Looking to say ColumnA starts with 1-6 in an AND Simple Filter.

I imagine there has to be an option using the Formula drop down, but I cannot find it. Any help would be greatly appreciated.

Robert Ricketts

1 comment

  • Avatar
    Alan Mark

    Hi Bo,

    You'll want to use the MATCHES function to achieve this.  Based on your description I'd use a REGEX pattern like:

    ^[1-6].*

    For details about what this means, plug it into regex101.com and try test string 1ABC.

    Let me know if you've got any further questions - also you can open up cases with support.

    0
Please sign in to leave a comment.