Return the position of one string within another, starting at the end of the string.

      InstrRev ( FullString, PartString, [start], [compare] )

   FullString  The String (expression) to be searched.

   PartString  The String (expression) being sought.

   Start       Number (expression) that sets the start position for each search.
               Default = -1 (the last character)

   compare     The comparison mode (Binary/Text)

The InStrRev() function can be used in VBA or in an SQL query.
The syntax for the InstrRev function is not consistent with the syntax for the Instr function.

Return values

If                          InStrRev() returns
String is found             Position at which match is found
FullString is zero-length   0
FullString is shorter than start  0
FullString is Null          Null

PartString is zero-length   start
PartString is Null          Null
PartString is not found     0


Dim intDemo as Integer
intDemo = InStrRev("The Universe is expanding", "U")
MsgBox intDemo

“One look is worth a thousand words” ~ Fred R. Barnard


Instr - Return the position of one string within another

Copyright © 1999-2024
Some rights reserved