Return the position of one string within another, starting by default at the beginning of the string.
Syntax Instr ( [start], FullString, PartString, [compare] ) Key Start Number (expression) that sets the start position for each search. Default = 1 FullString The String (expression) to be searched. PartString The String (expression) being sought. compare The comparison mode (Binary/Text)
The InStr() function can be used in VBA or in an SQL query.
If InStr() 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 = InStr("The Universe is everlasting ", "is")
intDemo = InStr(4, "The Universe is everlasting", "e")
“Believe those who are seeking the truth; doubt those who find it” ~ Andre Gide
InstrRev - Return the position of one string within another
Replace - Replace a sequence of characters in a string.