text string
Do you mean
=IF(OR(NOT(ISERROR(SEARCH("DLL",A3))),NOT(ISERROR( SEARCH("KEY",A3)))),"",IF(ISERROR(SEARCH("Blind
Discount",A3)),"","Blind Discount"))
--
__________________________________
HTH
Bob
"Dinesh" wrote in message
...
I have a following formula to extact text string.
=IF(ISERROR(SEARCH("Blind Discount",A3)),"","Blind Discount")
I want to add one more criteria. If the text string has "DLL" or "KEY"
word
in it, then I want result to be null otherwise "Blind Discount".
thanks,
Dinesh
|