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

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

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.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=515007

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

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

Again Thanks

Thank you for the feedback.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=515007