Looking for a Specific Character in a Specific Location in a String

[Philip1957]

Greetings,

I know how to use INSTR to see if a string contains a specific character, and I know how to use INSTR to return the index number of a character in a string.

How do I search a string for a specific character at a known index number? In other words, tell me if there is a 5 at index #3 .

It seems that this should be relatively easy but . . .

Thanks in advance for any assistance.

~ Phil

 

[Rick Rothstein]

If I understand your question correctly, generally like this...

If InStr("YourText", 5, 1) = SpecificCharacter Then

 

[Philip1957]

Thank you very much! I'll use this later this afternoon when I can get back to my VBA project.

I was close in my attempts. It's always the syntax that causes me problems.

Thank you again for your time.

~ Phil