Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
InstrRev Issue
I am trying to find the position of the last occurance of "\" in my string
using the below and all I get is 60 (always - i tried changing the position, string etc) which does not seem to be correct. MsgBox InStrRev(.FoundFiles(i), "\") Can anyone suggest what am I doing wrong? -- Ajit |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
InstrRev Issue
Syntax
InStrRev(string1, string2[, start[, compare]]) The InStrRev function syntax has these parts: Part Description string1 Required. String expression being searched. string2 Required. String expression being searched for. start Optional. Numeric expression that sets the starting position for each search. If omitted, -1 is used, which means that the search begins at the last character position. If start contains Null, an error occurs. compare Optional. Numeric value indicating the kind of comparison to use when evaluating substrings. If omitted, a binary comparison is performed. See Settings section for values. -- HTH, Barb Reinhardt "Ajit" wrote: I am trying to find the position of the last occurance of "\" in my string using the below and all I get is 60 (always - i tried changing the position, string etc) which does not seem to be correct. MsgBox InStrRev(.FoundFiles(i), "\") Can anyone suggest what am I doing wrong? -- Ajit |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL: How to scan text reversed (like ACCESS: InStrRev)? | Excel Worksheet Functions | |||
EXCEL: How to scan text reversed (like ACCESS: InStrRev)? | Excel Worksheet Functions | |||
Excel error: Undefined Function 'InStrRev' in Expression | Excel Worksheet Functions | |||
is there a instrRev function in excel functions? | Excel Worksheet Functions | |||
is there a instrRev function in excel functions? | Excel Worksheet Functions |