Find

[jonathan9560@gmail.com]

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

[BenjieLop]

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

Try this ...

=NOT(ISERROR(SEARCH("xxxxxx",A1)))

where xxxxxx = text that you want to search and
A1 = cell is where the string to be searched is in.

Hope this is what you are looking for ... regards.

[jonathan9560@gmail.com]

Thanks guys, both ways worked. I think I was looking for the SEARCH
function.

Again Thanks

[BenjieLop]

Thank you for the feedback.

Regards.

[Ron Coderre]

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


"jonathan9560@gmail.com" 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
>
>