Simple Filter - starts with "1-6"


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:


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

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

Please sign in to leave a comment.