For the Find, I'd suggest using:
.Text = "[A-Z]{2,}-[0-9A-Z\-]{1,}"
That should be sufficient to return all the strings you're concerned with. However, it's far from clear now what you want to do with them. You originally said:
Quote:
|
How do I format the return string for the Right function to find UPPERCASE letters
|
and provided pseudo-code for getting the two right-most characters. The code I posted does that, but I really have no idea what you want to do with what the Find returns.