You can use =search() or =find()

=if(isnumber(search("something",a1)),"found it","nope")

=find() is case sensitive
=search() isn't.

Lee Hunter wrote:

Is there anyway to use the InStr function in a formula or must I create a VBA
function to do it?

Thanks,
Lee

--

Dave Peterson