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

Thanks, Bill. I'll give this one a try also. It's good to have
alternatives.

JackBuff

"Bill Ridgeway" wrote:

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