Return the position of one string within another, starting at the end of the string.
Syntax InstrRev ( FullString, PartString, [start], [compare] ) Key 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.
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")
“One look is worth a thousand words” ~ Fred R. Barnard
Instr - Return the position of one string within another