do formulas have to be case sensative when searching words

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

If your example is all you want to do (that is, do a case-insensitive search
for some text in other text that returns TRUE or FALSE), you could do
this...

=NOT(ISERR(SEARCH("dog",A1)))

Rick
 
Back
Top