Is there a VBA wildcard for non-numeric characters only?

[svendiamond]

I want to know whether a string is Like "#???" or Like "##??"

But the question marks here need to be text only. I am only looking for a number followed by three non-numeric characters (i.e. text) or two numbers, followed by two non-numeric characters. How can I achieve this? Right now Excel is not knowing the difference because the question mark stands for "any character" - so what can I use as a wildcard to look for only non-numeric characters?

 

[Rick Rothstein]

I want to know whether a string is Like "#???" or Like "##??"

But the question marks here need to be text only. I am only looking for a number followed by three non-numeric characters (i.e. text) or two numbers, followed by two non-numeric characters. How can I achieve this? Right now Excel is not knowing the difference because the question mark stands for "any character" - so what can I use as a wildcard to look for only non-numeric characters?

I assume we are talking about the Like operator in VBA. The answer kind of depends on what you mean by non-numeric. Are you including punctuation marks as non-numeric or alphabetic letters only? I'll assume alphabetic letters (either upper or lower case). For your first part...

Like "#[A-Za-z][A-Za-z][A-Za-z]"

and for your second part...

Like "##[A-Za-z][A-Za-z]"

 

[RickXL]

Or you could do both parts together with:

Like "#[0-9A-Za-z][A-Za-z][A-Za-z]"

but it does depend on what you mean by "non-numeric characters". If you mean any non-numeric character then you might prefer this:

Like "#?[!0-9][!0-9]"

 

[svendiamond]

Awesome. Thank you both.