Dear Expert Excel,
I need to your help me to find way how to use FIND or SEARCH formula to check code in order to find letter "O", "I" in product code because of user it difficult to see letter between "0" (Zero) and "O".
I try to use FIND and OR in order to finding letter but does not work.
I can use only one condition as FIND("O",A2,1)
if i use OR formula in order to find letter "O" and "I" does not work.
Finding letter.xlsx
Bookmarks