There is a simple way to answer this ... try it!

It is not case sensitive in a straight comparison, there is an EXACT
function to achieve that.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"elaine" wrote in message
...
I am trying to use a formaul which looks at the contents of a cell,
however,
is it possible to construct a formula which is not case sensative?

E.g. does A1 contain "dog" - I want true if contains "DOG", "Dog" or "dog"