-2

I need to filter column A to see which cells end with values like .com/,.org/,.co.uk/, etc

Instead of filtering by "text ends with" dozens or hundreds of times, is there a way to combine all of these into one custom formula?

player0
  • 69,261
  • 8
  • 33
  • 67
LookingFor----
  • 17
  • 3
  • Does this answer your question? [What does the '|' (pipe character) mean in a regular expression?](https://stackoverflow.com/questions/22187880/what-does-the-pipe-character-mean-in-a-regular-expression) – Ryszard Czech May 01 '20 at 15:17

1 Answers1

0

try this custom formula for:

  • filter view
  • conditional formatting
  • data validation
=REGEXMATCH(A1, ".com/$|.org/$|.co.uk/$")

0

player0
  • 69,261
  • 8
  • 33
  • 67