On Tue, 27 Sep 2005 12:20:35 -0700, David Chapman wrote: >SEARCH allows regular expressions - including logical operators. > >To keep my example small, I have Dave in C2 and Greg in C3 > >My sentence is C4 > >=SEARCH(CONCATENATE(C2;"|";C3);C4) returns a non-error value if the sentence C4 >contains Dave or Gerry
>> I have a list of 'phrases' in cells h100:h110. >> >> Overdraft Charge [snip] >> BOFA MS >> Monthly Maintenance Fee >> >> I have a 'sentence' in cell C3 that may contain one of these phrases. >> ACH DB Bofa MS 19299 Merch Fees >> I want to write a formula that will compare the list of phrases to the >> words in C3 and show if there is a match. >> I went nuts 'till I re-read the "You can switch the automatic evaluation of regular expression on and off in Tools - Options - OpenOffice.org Calc - Calculate." in the helps.. It HAS to be ON ?for text? =IF(ISERR(SEARCH(CONCATENATE(C2;"|";C3);C4));"no";"yes") -- Greg Agent 1.93/32.576 Opera8 OOo2(19125) news.readfreenews.net & news.gmane.org Win98se for sale: Apple//,Auto Parts/Equip/Manuals: geardocATgeardoc36DOThostingisfreeDOTcom --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
