"Without a ton of details on what you need, I???ll make a few assumptions to make my answer work: 1. the resulting format will be ???xyy??? where x is a letter and yy is a 2-digit number with leading zeros, 2." . . . .