R
rayybay
Could that formula be modifed so after 26 characters, it started with A1,
B1... instead of AA, AB...?
B1... instead of AA, AB...?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
rayybay said:Could that formula be modifed so after 26 characters, it started with A1,
B1... instead of AA, AB...?
Try this in any starting cell, say in B2:
=IF(ROWS($1:1)>26,CHAR(MOD(ROWS($1:1)-1,26)+65)&INT((ROWS($1:1)-1)/26),CHAR(MOD(ROWS($1:1)-1,26)+65))
Copy down as far as required.
The expression will return the series:
A,B, ... Z,A1,B1, ... Z1,A2,B2, ... Z2,A3,B3 ... and so on, all the way
R
rayybay
PERFECT!!! Thank you!
Max said:Try this in any starting cell, say in B2:
=IF(ROWS($1:1)>26,CHAR(MOD(ROWS($1:1)-1,26)+65)&INT((ROWS($1:1)-1)/26),CHAR(MOD(ROWS($1:1)-1,26)+65))
Copy down as far as required.
The expression will return the series:
A,B, ... Z,A1,B1, ... Z1,A2,B2, ... Z2,A3,B3 ... and so on, all the way
M
Max
Welcome, glad to hear that