Equation to remove last character if letter and first leading 0

[NormChart55]

Hello,

I am looking for a way to remove letters if they appear at the end of an item as well as removing a 0 only if it appears between 000 and 099 after the characters "RV". I have an example list below and hoping there is an easy way to remove these from a mass list with a formula. Thanks for any information and help.

Examples
Store numbers - always starts with RV and could go up to RV9999a (or b,c,d,e)

RV002A - should be RV02
RV050G - should be RV50
RV027H - should be RV27
RV1000 - should be RV1000
RV429A - should be RV429

 

[Joe4]

Thanks for the information. There is only ever 1 letter. I applied this one, but I am getting the stores that are between 1-10 do not have a 0.

Example: WZ002A -> goes to WZ2 but should be WZ02. All others are coming out as expected

Sorry, I overlooked that part. I though you wanted all leading zeroes on the number portion dropped.

 

[awoohaw]

Thanks. This one removes the letter but still leaves the leading 0s for me

I think it matches your sample, so I'm not sure what you mean. You have an example output with one leading zero. But, you've got a solution. So that is good.

 

[Fluff]

Glad we could help & thanks for the feedback.