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
Bookmarks