View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bill Ridgeway
 
Posts: n/a
Default Excel -find records which DO NOT contain a particular text string

One way would be to have a helper column-
=IF(ISNUMBER(SEARCH("YYY",A1)),1,0)
which will return 1 if the cell has the text YYY and 0(zero) if not

Regards.

Bill Ridgeway
Computer Solutions

"JackBuff" wrote in message
...
I am trying to find all records which DO NOT contain a particular text
string. Can someone help me with some ideas.

THanks