用EXCEL公式复现 列序号数列：A,B,C,,,Z,AA,AZ,,,
2 原始数据和过程| A | 1 | A | A | $A$1 | $A | A | A | $A$1 | $A | A | ||||
| B | 2 | B | B | $B$1 | $B | B | B | $B$1 | $B | B | ||||
| C | 3 | C | C | $C$1 | $C | C | C | $C$1 | $C | C | ||||
| D | 4 | D | D | $D$1 | $D | D | D | $D$1 | $D | D | ||||
| E | 5 | E | E | $E$1 | $E | E | E | $E$1 | $E | E | ||||
| F | 6 | F | F | $F$1 | $F | F | F | $F$1 | $F | F | ||||
| G | 7 | G | G | $G$1 | $G | G | G | $G$1 | $G | G | ||||
| H | 8 | H | H | $H$1 | $H | H | H | $H$1 | $H | H | ||||
| I | 9 | I | I | $I$1 | $I | I | I | $I$1 | $I | I | ||||
| J | 10 | J | J | $J$1 | $J | J | J | $J$1 | $J | J | ||||
| K | 11 | K | K | $K$1 | $K | K | K | $K$1 | $K | K | ||||
| L | 12 | L | L | $L$1 | $L | L | L | $L$1 | $L | L | ||||
| M | 13 | M | M | $M$1 | $M | M | M | $M$1 | $M | M | ||||
| N | 14 | N | N | $N$1 | $N | N | N | $N$1 | $N | N | ||||
| O | 15 | O | O | $O$1 | $O | O | O | $O$1 | $O | O | ||||
| P | 16 | P | P | $P$1 | $P | P | P | $P$1 | $P | P | ||||
| Q | 17 | Q | Q | $Q$1 | $Q | Q | Q | $Q$1 | $Q | Q | ||||
| R | 18 | R | R | $R$1 | $R | R | R | $R$1 | $R | R | ||||
| S | 19 | S | S | $S$1 | $S | S | S | $S$1 | $S | S | ||||
| T | 20 | T | T | $T$1 | $T | T | T | $T$1 | $T | T | ||||
| U | 21 | U | U | $U$1 | $U | U | U | $U$1 | $U | U | ||||
| V | 22 | V | V | $V$1 | $V | V | V | $V$1 | $V | V | ||||
| W | 23 | W | W | $W$1 | $W | W | W | $W$1 | $W | W | ||||
| X | 24 | X | X | $X$1 | $X | X | X | $X$1 | $X | X | ||||
| Y | 25 | Y | Y | $Y$1 | $Y | Y | Y | $Y$1 | $Y | Y | ||||
| Z | 26 | Z | Z | $Z$1 | $Z | Z | Z | $Z$1 | $Z | Z | ||||
| [ | 1 | 1 | AA | AA | $AA$1 | $AA | AA | AA | $AA$1 | $AA | AA | |||
| 1 | 2 | AB | AB | $AB$1 | $AB | AB | AB | $AB$1 | $AB | AB | ||||
| ] | 1 | 3 | AC | AC | $AC$1 | $AC | AC | AC | $AC$1 | $AC | AC | |||
| ^ | 1 | 4 | AD | AD | $AD$1 | $AD | AD | AD | $AD$1 | $AD | AD | |||
| _ | 1 | 5 | AE | AE | $AE$1 | $AE | AE | AE | $AE$1 | $AE | AE | |||
| ` | 1 | 6 | AF | AF | $AF$1 | $AF | AF | AF | $AF$1 | $AF | AF | |||
| a | 1 | 7 | AG | AG | $AG$1 | $AG | AG | AG | $AG$1 | $AG | AG | |||
| b | 1 | 8 | AH | AH | $AH$1 | $AH | AH | AH | $AH$1 | $AH | AH | |||
| c | 1 | 9 | AI | AI | $AI$1 | $AI | AI | AI | $AI$1 | $AI | AI | |||
| d | 1 | 10 | AJ | AJ | $AJ$1 | $AJ | AJ | AJ | $AJ$1 | $AJ | AJ | |||
| e | 1 | 11 | AK | AK | $AK$1 | $AK | AK | AK | $AK$1 | $AK | AK | |||
| f | 1 | 12 | AL | AL | $AL$1 | $AL | AL | AL | $AL$1 | $AL | AL | |||
| g | 1 | 13 | AM | AM | $AM$1 | $AM | AM | AM | $AM$1 | $AM | AM | |||
| h | 1 | 14 | AN | AN | $AN$1 | $AN | AN | AN | $AN$1 | $AN | AN | |||
| i | 1 | 15 | AO | AO | $AO$1 | $AO | AO | AO | $AO$1 | $AO | AO | |||
| j | 1 | 16 | AP | AP | $AP$1 | $AP | AP | AP | $AP$1 | $AP | AP | |||
| k | 1 | 17 | AQ | AQ | $AQ$1 | $AQ | AQ | AQ | $AQ$1 | $AQ | AQ | |||
| l | 1 | 18 | AR | AR | $AR$1 | $AR | AR | AR | $AR$1 | $AR | AR | |||
| m | 1 | 19 | AS | AS | $AS$1 | $AS | AS | AS | $AS$1 | $AS | AS | |||
| n | 1 | 20 | AT | AT | $AT$1 | $AT | AT | AT | $AT$1 | $AT | AT | |||
| o | 1 | 21 | AU | AU | $AU$1 | $AU | AU | AU | $AU$1 | $AU | AU | |||
| p | 1 | 22 | AV | AV | $AV$1 | $AV | AV | AV | $AV$1 | $AV | AV | |||
| q | 1 | 23 | AW | AW | $AW$1 | $AW | AW | AW | $AW$1 | $AW | AW | |||
| r | 1 | 24 | AX | AX | $AX$1 | $AX | AX | AX | $AX$1 | $AX | AX | |||
| s | 1 | 25 | AY | AY | $AY$1 | $AY | AY | AY | $AY$1 | $AY | AY | |||
| t | 1 | 26 | AZ | AZ | $AZ$1 | $AZ | AZ | AZ | $AZ$1 | $AZ | AZ | |||
| u | 2 | 1 | BA | BA | $BA$1 | $BA | BA | BA | $BA$1 | $BA | BA | |||
| v | 2 | 2 | BB | BB | $BB$1 | $BB | BB | BB | $BB$1 | $BB | BB | |||
| w | 2 | 3 | BC | BC | $BC$1 | $BC | BC | BC | $BC$1 | $BC | BC | |||
| x | 2 | 4 | BD | BD | $BD$1 | $BD | BD | BD | $BD$1 | $BD | BD | |||
| y | 2 | 5 | BE | BE | $BE$1 | $BE | BE | BE | $BE$1 | $BE | BE | |||
| z | 2 | 6 | BF | BF | $BF$1 | $BF | BF | BF | $BF$1 | $BF | BF | |||
| { | 2 | 7 | BG | BG | $BG$1 | $BG | BG | BG | $BG$1 | $BG | BG | |||
| | | 2 | 8 | BH | |||||||||||
| } | 2 | 9 | BI | |||||||||||
| ~ | 2 | 10 | BJ | |||||||||||
| 2 | 11 | BK | ||||||||||||
| 2 | 12 | BL | ||||||||||||
| 2 | 13 | BM | ||||||||||||
| 2 | 14 | BN | ||||||||||||
| 2 | 15 | BO | ||||||||||||
| 2 | 16 | BP | ||||||||||||
| 2 | 17 | BQ | ||||||||||||
| 2 | 18 | BR | ||||||||||||
| 2 | 19 | BS | ||||||||||||
| 2 | 20 | BT | ||||||||||||
| 2 | 21 | BU | ||||||||||||
| 2 | 22 | BV | ||||||||||||
| 2 | 23 | BW | ||||||||||||
| 2 | 24 | BX | ||||||||||||
| 2 | 25 | BY | ||||||||||||
| 2 | 26 | BZ | ||||||||||||
单元格A1=CHAr(64+ROW(A1))核心就是 把字符用ascii表示，使用char()函数
方法2：CDE列，其中CD为辅助列分别用量辅助列单元格E1=CHAr(64+D1)单元格E27=CHAr(64+C27)&CHAr(64+D27)不再直接区，行数作为参数，而是直接加2列数组作为参数，影响最终数组把A-Z和另外一个A-Z 连接起来
方法3,列G,其中列H,I,J是按步骤拆分计算列单元格G1=MId(SUBSTITUTE(ADDRESS(1,ROW(G1)),"$1",""),2,9)ADDRESS(1,ROW(G1)=$A$1SUBSTITUTE(ADDRESS(1,ROW(G1)),"$1","")=$AMId(SUBSTITUTE(ADDRESS(1,ROW(G1)),"$1",""),2,9)=A核心就是，用address() 函数可以获取，单元格的 A1显示格式，然后去掉行号，就剩下要的数组序列了
方法4,列L,其中列M,N,O是按步骤拆分计算列单元格L1=SUBSTITUTE(SUBSTITUTE(ADDRESS(1,ROW()),"$1",""),"$","")ADDRESS(1,ROW()=$A$1SUBSTITUTE(ADDRESS(1,ROW()),"$1","")=$ASUBSTITUTE(SUBSTITUTE(ADDRESS(1,ROW()),"$1",""),"$","")=A
