oops, may have spoke too soon, found some material to study, but if these
don't apply feel free to suggest, thanks; If this covers what looking for
(was going to expand on having complete letter groups tested for in a cell..
eg: bd, bsd, spd)

found material:
=OR(FIND(CM9,"H"),FIND(CM9,"X")) for CF:
=OR(ISNUMBER(FIND("H",A1)),ISNUMBER(FIND("X",A1)))

Alternatively, if you have a lot of FINDs to do, just create* a defined
range, eg: MyR to refer to, eg: ={"H";"X";"Z"} *via InsertNameDefine
Then you could use this in the CF's formula:
=SUMPRODUCT(--ISNUMBER(FIND(MyR,A1)))0

=SEARCH("h",CM9) to something like: =OR(FIND(CM9,"H"),FIND(CM9,"X"))

=ISNUMBER(SEARCH("h*h",A1)) and for your second conditional formula...
=ISNUMBER(SEARCH("h*x",A1)) Note, both of these are case insensitive.

For your first conditional formula... =ISNUMBER(SEARCH("h*h",A1)) That will find false positives like: thigh thorough haha happy birthday





________________

"Nastech" wrote:

080425 FIND 1 char in cell of any 3 char =True

been having trouble figuring out SEARCH & FIND, trying to find if a
character in a cell is present. do not see any TRUE/FALSE examples, just a
bunch of errors.

finally have following work in a cond. format:
=SEARCH(A9,$A$2)

where only 1 character/number exists in A9, and multiple chars in $A$2

now need to test A9 if has "H" for e.g.: HLA
actually need to test for multiple characters in A9, e.g.: "X","H"
would use fixed cell to test for, to save space
would use smaller functions to save space, FIND instead of SEARCH, but not
critical
thanks