excel电子表格怎么用公式解决这个问题

显示全部楼层 · 2013-7-28 10:34:07

=CHAR(INT(ROW(A104)/104)+64)&CHAR(MOD(INT(ROW(A4)/4)-1,26)+65)&MOD(ROW(A4),4)+1...

千问 · 2013-7-28 10:34:07

请在A1输入以下公式，下拉=(CHAR((INT((ROW()-1)/26)+65)))&(CHAR((MOD(ROW()-1,26)+65)))&(MOD(ROW()-1,4)+1)...

千问 · 2013-7-28 10:34:07

=CHAR(MOD(INT((ROW(A1)-1)/104),104)+65)&CHAR(MOD(INT((ROW(A1)-1)/4),26)+65)&MOD(ROW(A1)-1,4)+1下拉填充...

千问 · 2013-7-28 10:34:07

=CHAR(65+INT(ROW(A1)/105))&CHAR(MOD(INT((ROW(A1)-1)/4),26)+65)&IF(MOD(ROW(A1),4)=0,4,MOD(ROW(A1),4))...

千问 · 2013-7-28 10:34:07

=IF(RIGHT(A1,1)+0>3,IF(CODE(MID(A1,2,1))>CODE("y"),IF(CODE(LEFT(A1,1))>CODE("y"),"x",CONCATENATE(,CHAR(CODE(LEFT(A1,1))+1),"a1")),CONCATENATE(LEFT(A1,1),CHAR(CODE(MID(A1,2,1))+1),"...