Gary''s Student wrote:
Glenn your formula is great!


Thanks, but I may have overestimated it's effectiveness...probably closer to
475,000 rows. Which means in Excel 2007 you would need to add another layer to
cover the whole possible column:

=IF(ROW()932230,"B",IF(ROW()475254,"A",""))&
IF(ROW()18277,CHAR(64+MOD(INT((ROW()-18279)/17576),26)+1),"")&
IF(ROW()702,CHAR(64+MOD(INT((ROW()-703)/676),26)+1),"")&
IF(ROW()26,CHAR(64+MOD(INT((ROW()-27)/26),26)+1),"")&
CHAR(64+MOD(ROW()-1,26)+1)