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"