I am trying to make a sort list with numbers and letters.
1a
1b
1c < when z is done it goes to
2a
2b
2c
etc…
but i need to go to to 5000.
is it possible to do or is there a formula that can help.
To cell A1:
=INT((ROW(A1)+25)/26)&CHAR(CODE("a")+MOD(ROW(A1)-1;26))
and drag the formula down.
To quickly fill in the bottom cells with a formula after entering the formula in cell A1:
- Enter in the Name box (box with cell address):
A1:A5000and press Enter. Cells A1:A5000 should be selected. - Press Ctrl+D
2 Likes