Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I it possible to use the Instr() function with multiple search terms. The
idea being that all below should return a value fo 1 Dim Y as Double Y = Instr(1, "Hello World", "Hello|"The"|"Dog") Y = Instr(1, "The World", "Hello|"The"|"Dog") Y = Instr(1, "Dog World", "Hello|"The"|"Dog") The idea here being to find matches at the beginning of the Target String. Alternatively I could use Regular Expressions. But I cannot remember how to use the Match functionality to return the position of the word. Thanks EM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
is there an equal fxn for 'InStr' in excel. Not Find or Search | Excel Worksheet Functions | |||
Two search category & two search terms | Excel Discussion (Misc queries) | |||
Search returning ans in terms of Rows & Columns | Excel Discussion (Misc queries) | |||
searching a large database with a long list of search terms | Excel Discussion (Misc queries) | |||
how to set up a vlookup table with 2 search terms? | Excel Worksheet Functions |