Find

J

jonathan9560

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
 
B

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
Click to expand...

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
 
R

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
 
J

jonathan9560

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

Again Thanks
 
Top