Simple Filter - starts with "1-6"

Follow

Robert Ricketts

• April 16, 2018 16:34

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.

0

• 

  Alan

  • April 16, 2018 16:47

  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

  Comment actions Permalink

Please sign in to leave a comment.