Need to replace X in text with A through F

Good day all,

I am a Excel VBA rookie (to say the least.) I have a file from an external department that uses "X" as a wildcard to represent the characters A through F in a series of part numbers. I have created some code so that the parts that contain an X is listed 6 times in the original column. Now I want to go through that column that contains those parts (in this case, column B) and, for each X, replace with its appropriate character.

For example:

AL4500X03-E6 in rows 9 through 14 in column B becomes:

AL4500A03-E6
AL4500B03-E6
AL4500C03-E6
AL4500D03-E6
AL4500E03-E6
AL4500F03-E6

And then continue on to the next item that contains an X and replace with A through F in each case again.

Appreciate any help you can offer!

Thanks
Adam

Can you post a sample workbook? Is the X always the 7th character?

Sure thing. Yes, X is always the 7th character in the part numbers I'm working with. You will see from the sample, not all the parts in column B will have a wildcard X.