Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP! Search rule is case sensitive!!
Hi all,
I am trying to find specific text sequences in a large, multi-colum spreadhseet ... I am using IF(ISNUMBER(FIND("<text",<cell),1,"") ... While it works I note it is case-sensitive ..... Is there anyway to resolve this? I have tried using an OR function but that doesn't appear to work. Help greatly appreciated, Don- |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP! Search rule is case sensitive!!
Use SEARCH() instead...
In article , Don wrote: Hi all, I am trying to find specific text sequences in a large, multi-colum spreadhseet ... I am using IF(ISNUMBER(FIND("<text",<cell),1,"") ... While it works I note it is case-sensitive ..... Is there anyway to resolve this? I have tried using an OR function but that doesn't appear to work. Help greatly appreciated, Don- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP! Search rule is case sensitive!!
What does Excel help for the FIND function say in answer to your question?
-- David Biddulph Don wrote: Hi all, I am trying to find specific text sequences in a large, multi-colum spreadhseet ... I am using IF(ISNUMBER(FIND("<text",<cell),1,"") ... While it works I note it is case-sensitive ..... Is there anyway to resolve this? I have tried using an OR function but that doesn't appear to work. Help greatly appreciated, Don- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Case sensitive filter | Excel Worksheet Functions | |||
Validation ... Case Sensitive? | Excel Discussion (Misc queries) | |||
Case sensitive filtering | Excel Discussion (Misc queries) | |||
Case Sensitive w/ IF | Excel Worksheet Functions | |||
Case sensitive vlookup | Excel Discussion (Misc queries) |