See if one of these works for you:

If you want to check if a cell contains "ABC" or "JK" or "MNO":
B1: =SUMPRODUCT(COUNTIF(A1,"*"&{"ABC","JK","MNO"}&"*") )0

If you only need to check for one string (example: "JK"):
B1: =COUNTIF(A1,"*JK*")0

(note: COUNTIF is not case sensitive)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


" wrote:

I am trying to find a cell containing the letters I know, is there a
function that allows wildcard characters.

For ex:

I want to find "HIJ" or "HI" or "HIJKL"

in Cells containing string of letters: "ABCDEFGHIJKLMNOPQRS"

Thanks,

J9