I need a formula so that if it finds two specified groups of text in a cell (say cell A1) then it would put a specified text in another cell (say cell A2).
For example, the contents of cell A1 is "1RXXXLPXX". Since "1R" and "LP" are in cell A1, I need it to put a specific word in cell A2.
I know how to make it find just "1R" in cell A1 and put a word in cell A2 - I'm using:
=IF(ISNUMBER(SEARCH("1R",$C56)),"1R")
But I don't know how to make it find "1R" AND "LP".
Any help would be appreciated!!
Bookmarks