Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SEARCH(find_text,within_text,start_num)
Hi there,
Is there a way to specify the 'find_text' to be one of a selection of strings? For instance: SEARCH("blue" or "red",B2,1) To look for either the words blue or red/ Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SEARCH(find_text,within_text,start_num)
It depends on how you're using it:
=OR(ISNUMBER(SEARCH({"blue","red"},B2))) -- Biff Microsoft Excel MVP "dangerd" wrote in message ups.com... Hi there, Is there a way to specify the 'find_text' to be one of a selection of strings? For instance: SEARCH("blue" or "red",B2,1) To look for either the words blue or red/ Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SEARCH(find_text,within_text,start_num)
On 30 Oct, 17:30, "T. Valko" wrote:
It depends on how you're using it: =OR(ISNUMBER(SEARCH({"blue","red"},B2))) -- Biff Microsoft Excel MVP "dangerd" wrote in message ups.com... Hi there, Is there a way to specify the 'find_text' to be one of a selection of strings? For instance: SEARCH("blue" or "red",B2,1) To look for either the words blue or red/ Thanks- Hide quoted text - - Show quoted text - Humm thanks, I don't know what you mean. I am using it in the following way: =IF(ISNUMBER(OR(SEARCH({"*red*","*blue*"},F3))),"f ood",) but it does not work. Any idea? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
SEARCH(find_text,within_text,start_num)
Try it like this:
=IF(OR(ISNUMBER(SEARCH({"blue","red"},F3))),"food" ,"") -- Biff Microsoft Excel MVP "dangerd" wrote in message ups.com... On 30 Oct, 17:30, "T. Valko" wrote: It depends on how you're using it: =OR(ISNUMBER(SEARCH({"blue","red"},B2))) -- Biff Microsoft Excel MVP "dangerd" wrote in message ups.com... Hi there, Is there a way to specify the 'find_text' to be one of a selection of strings? For instance: SEARCH("blue" or "red",B2,1) To look for either the words blue or red/ Thanks- Hide quoted text - - Show quoted text - Humm thanks, I don't know what you mean. I am using it in the following way: =IF(ISNUMBER(OR(SEARCH({"*red*","*blue*"},F3))),"f ood",) but it does not work. Any idea? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Worksheet Functions | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Setting up and Configuration of Excel | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Links and Linking in Excel | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Charts and Charting in Excel | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions |