Hi Janus
Perhaps by using this 3 ton formula I saved from Bernie Deitrick (12/22000).
=CHAR((A1-(A1-INT(A1/26)*26)-((A1-(A1-INT(A1/26)*26))/26-INT((A1-(A1-INT(A1/26)*26))/26/26)*26)*26)/26/26-INT((A1-(A1-INT(A1/26)*26)-((A1-(A1-INT(A1/26)*26))/26-INT((A1-(A1-INT(A1/26)*26))/26/26)*26)*26)/26/26/26)*26*26+97)&CHAR((A1-(A1-INT(A1/26)*26))/26-INT((A1-(A1-INT(A1/26)*26))/26/26)*26+97)&CHAR(A1-INT(A1/26)*26+97)
Copy - Paste in B1.
In C1 enter =RIGHT(B1,2)
In A1 enter a 0 (zero). B1 will show "aaa"
Select the three columns and pull down to no more than 677 rows.
Past that C column will begin to duplicate. If having 3 letters in your
lettering system is OK, then omit the C column and use the B column results.
ZZZ occurs at 17,576.
To get rid of the formulas do a copy and paste special values.
I can not answer ANY questions about this formula. I also made the mistake
of just printing it out instead of saving in Excel. Typing it back into
Excel was a virtual disaster. Hit enter and "... your formula is missing a
(..." 'bout 50 times it seemed! :)
A just as an aside, my initials LHK occur in row 7629.
HTH
Regards,
Howard
"Janus" wrote in
message ...
I can easily create a column of numbers that increase in increments of 1
in each successive cell by adding 1 to the cell above. The first cell
is the only cell where I manually input a number. I want to set a
column so that I can input a letter, say E, in the top cell and the
cells below will fill in with F, G, H, etc. If this can be done, am I
limited to a maximum of 26 cells to match the number of letters in the
alphabet, or can I go into letters like AA, AB, AC, etc.
--
Janus
------------------------------------------------------------------------
Janus's Profile:
http://www.excelforum.com/member.php...o&userid=26890
View this thread: http://www.excelforum.com/showthread...hreadid=477252