how to repeat the letters when you reach number 26

[hazemrezo]

Hi every one

i want to repeat the alphabet from a to z to one number then the sam number will be for Example 1050A and i want when i drag this number to z turned to
1050 AA and keep on when i drag to anther z to be 1050AAA as you can see in attached

[southward]

Hi,

I think what you are looking for can be found at:

https://www.pcreview.co.uk/threads/h...to-zz.1010611/

Hope this works for you.

Cheers

[newdoverman]

This might work for you. No helper columns are used. I entered this formula in G2 and filled down.

Please Login or Register  to view this content.