Workaround to overcome 50.000 cell limit

  1. B1 =TEXTJOIN(A1:A26000)
  2. B2 =TEXTJOIN(A26001:A52000)
  3. Create two RegEx match filters with B1 OR B2, (OR as condition between filters)
Job done.

Login or Signup to post a comment