Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
do formulas have to be case sensative when searching words
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" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
do formulas have to be case sensative when searching words
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" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
do formulas have to be case sensative when searching words
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" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you change letter case without having to retype words? | Excel Discussion (Misc queries) | |||
Pivot tables and grouping words that are both upper and lower case | Excel Worksheet Functions | |||
New case of Month Formulas | Excel Discussion (Misc queries) | |||
Formulas dealing with searching for characters | Excel Worksheet Functions | |||
Searching for the presence of specific words | Excel Worksheet Functions |