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