Function to find "Invalid" in a string

  • Thread starter Thread starter JMay
  • Start date Start date
J

JMay

Is there a function to find a test string within another test string?
I need to find the cells within the Range a1:a2000 which include the
text "Invalid" anywhere within the Cells A1:A2000.
But How?
Not Find() or Search(), but What?
 
Hi:

For a non-programming solution, why not use conditional formatting? Select
the range with A1 active, then from the menu, do Format | Conditional
Formatting | Formula Is | =SEARCH("invalid",A1)>0 | Color red.

Regards,

Vasant.
 
Back
Top