Thread: text string
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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