The Microsoft Excel INSTR function returns the position of the first occurrence of a substring in a string. The INSTR function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a VBA function (VBA) in Excel.
How do I use the InStr function?
Syntax of InStr Function
- [Start] – (optional argument) this is an integer value that tells the InStr function the starting position from which it should start looking. ...
- String1 – This is the main string (or the parent string) in which you want to search. ...
- String2 – This is the substring that you are searching for.
What is the InStr function?
Purpose. The INSTR functions search string for substring . The function returns an integer indicating the position of the character in string that is the first character of this occurrence. INSTR calculates strings using characters as defined by the input character set.
