I'm trying to filter my sheet with <pre class="prettyprint"><code>=filter({B:B}, regexmatch({B:B}, $A$1)) </code></pre> Is it possible to make regexmatch case insensitive?

You can use: <pre class="prettyprint"><code>=regexmatch($I1,"(?i)tex") </code></pre>

How to do case insensitive match with regexmatch in google sheets?

I'm trying to filter my sheet with

=filter({B:B}, regexmatch({B:B}, $A$1))

Is it possible to make regexmatch case insensitive?

974

asked Jan 03 '19 21:01

You can use:

=regexmatch($I1,"(?i)tex")

answered Sep 28 '22 04:09

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!