I have some rows in some columns contains something like

• #Invalid Ref: 234566
• #Invalid Ref: 123445
• #Invalid Ref: 235678

I am trying to use find and replace by regular expression to find any row that contains any of the above and replace it with empty

what is the best regular expression I can use?

CodePudding user response：

If the last numbers are always six digits, this should work. See