InStrExact - Find Location Of A Word, As A Word, Not Embedded Within Another Word

[Rick Rothstein]

I posted this article two-and-quarter years ago and, until now, no one noticed that my code does not work correctlyy for the example I give in the beginning description!??!! Someone in another forum posted that all he could get InStrExact to return when looking for "Don" in "Don't tell me, but your name is Don, right?" is the number 1, not 33. And when I tried it, that is what I got as well. Now I can almost understand my missing this... almost, but not one of the 3,148 people who have viewed the article as of today noticed it until now? Anyway, I have posted corrected code in Message #1, so if you are currently using the original function, please replace it with what is now posted there.

[KingTamo]

I posted this article two-and-quarter years ago and, until now, no one noticed that my code does not work correctlyy for the example I give in the beginning description!??!! Someone in another forum posted that all he could get InStrExact to return when looking for "Don" in "Don't tell me, but your name is Don, right?" is the number 1, not 33. And when I tried it, that is what I got as well. Now I can almost understand my missing this... almost, but not one of the 3,148 people who have viewed the article as of today noticed it until now? Anyway, I have posted corrected code in Message #1, so if you are currently using the original function, please replace it with what is now posted there.

Hi Mr. Rick
I tested your great UDF function and noticed that case sensitive doesn't work properly

Sub TestRun()
    MsgBox InStrExact(1, "Don't tell me, but your name is Don, right?", "Don", 1)
End Sub

The optional argument case sensitive .. I tried to put 0 and 1 .. I got the same result 33
Is there any thing wrong about it?

[Rick Rothstein]

Hi Mr. Rick
I tested your great UDF function and noticed that case sensitive doesn't work properly

Sub TestRun()
    MsgBox InStrExact(1, "Don't tell me, but your name is Don, right?", "Don", 1)
End Sub

The optional argument case sensitive .. I tried to put 0 and 1 .. I got the same result 33
Is there any thing wrong about it?

Since the word you are searching for has the same letter casing as the word in the text, a case sensitive and case insensitive search will always return the same value. Try changing the red highlighted word to "don" instead of "Don" and then try 0 and 1 for the 4th argument to see the difference