The solution to this is probably quite easy, however, I'm new to the
whole world of Excel Programming with VBA. Here's the situation:

User makes an input. The input is always in the same format and is
assigned to a variable called AppID. The format of the input is
xxx-xxxxx-xx, where x can be any combination of letters and numbers.
How do I do this: If the 5th character from the left of AppID is equal
to 0, then I want to create a new variable, called AppID2, but the 5th
character of AppID2 will be changed from 0 to V.

Any help is much appreciated!

Rick