Return the position of one string within another, starting by default at the beginning of the string.

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

   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.

Return values

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")
MsgBox intDemo

intDemo = InStr(4, "The Universe is everlasting", "e")
MsgBox intDemo

“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.

Copyright © 1999-2019
Some rights reserved