VBA Instr Command tutorial
VBA Instr Command - how to use the vba instr command
The instring command is useful in determining if a word or combination of characters exist in a text string. It returns 0 when it doesn't find the string. if it does it returns the position of the start of the word or collection of characters.
1. It does so from left to right
2. use the instrrev() if you need right to left
3. It must be an exact match - yes it is case sensitive
3. it must be an exact match