excel 英文递增
- font size decrease font size increase font size
A1输入公式后向下拉 =IF(CEILING(ROW()/511758,1)-1=0,"",CHAR(MOD(CEILING(ROW()/511758,1)-2,26)+65))&IF(CEILING(ROW()/18954,1)-1=0,"",CHAR(MOD(CEILING(ROW()/18954,1)-2,26)+65))&IF(CEILING(ROW()/702,1)-1=0,"",CHAR(MOD(CEILING(ROW()/702,1)-2,26)+65))&IF(CEILING(ROW()/26,1)-1=0,"",CHAR(MOD(CEILING(ROW()/26,1)-2,26)+65))&CHAR(MOD((ROW()-1),26)+65)
Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php on line 169
- Published in Office - microsoft office
- Read 1696 times
Notice: Only variables should be assigned by reference in /var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php on line 478