String within a string test?

[roscoe]

Call me stupid, but I can't figure out to develop a simple test to see if a 1 character string exists within another string. I have been trying to use the FIND command but it generates error messsages when the string is not included and they are killing me.

Any help on a simple test that results in TRUE or FALSE?

Thanks!
Merry Christmas!

 

[barry houdini]

Try a variation of this

=ISNUMBER(FIND("a",A1))

FIND is case-sensitive, switch to SEARCH if you don't want it to be case-sensitive

 

[roscoe]

Interesting. Will give it a try.

Thanks!