28 Eylül 2012

Hexavigesimal Base26


This excel formula creates a base26 array. You can create sequential hexavigesimal arrays like AA, AB, AC, AD. This sequential array could be useful at database applications. 

=IF(ROW(A1)<27;"";CHAR(64+INT((ROW(A1)-1)/26)))&CHAR(65+MOD(ROW(A1)-1;26))



0 comments :