Hi Everyone,
I'm working on a formula to find multiple occurences of different text strings within a single cell. The problem is with one formula will find one text string, but I dont know how to tell to find the others. I have another one that can find either or, but wont return a blank cell if it cant find anything
=IF(ISNUMBER(SEARCH("*BLAH-2*",J5)),"BLAH-2","")
=IF(SUM(COUNTIF(G67,{"*BLAH-2*","*GOOD-3*"}))>0,"BLAH-2","GOOD-3")
Any assistance will greatly be appreciated
MZING81
I'm working on a formula to find multiple occurences of different text strings within a single cell. The problem is with one formula will find one text string, but I dont know how to tell to find the others. I have another one that can find either or, but wont return a blank cell if it cant find anything
=IF(ISNUMBER(SEARCH("*BLAH-2*",J5)),"BLAH-2","")
=IF(SUM(COUNTIF(G67,{"*BLAH-2*","*GOOD-3*"}))>0,"BLAH-2","GOOD-3")
Any assistance will greatly be appreciated
MZING81