Hi,

I have a column of references such as:

602
602
603
604
604
604

I need some VBA to add a letter on the end of each string to make each one unique. So the above should read:

602A
602B
603A
604A
604B
604C

There is always a different amount of references in column A so need VBA to automatically detect this and change each one. Once it gets to Z, it should carry on with AA, AB, AC, etc.

Thanks for your help.