Hi,

Is there a way to search for a specific sequence / combination of uppercase and lowercase characters within a string?

I want to search for the substring " and UU", "UUU of " and "###) of" within a string, where "U" indicates an uppercase letter, and "#" indicates a number.

I don't believe I can use InStr, as this doesn't accept wildcards. And as far as I'm aware, the Like operator is not case sensitive.

Cheers