Edit single character within a variable

[rickdogg03]

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

[LenB]

Try this.

If Mid(AppID, 5, 1) = "0" Then
AppID2 = AppID
Mid(AppID2, 5, 1) = "V"
End If

rickdogg03 wrote:
> 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
>

[rickdogg03]

Thanks LenB! I didn't even know about the built-in Mid function.