如何在Excel中进行有规则的转换

热线

有下面数据：
33030031330101
30101133013001
.
.
.

条件是：

将第一列和第二列组合成0-8中的一个数，第三列和第四列组合成0-8中的一个数，第五列和第六列组合成0-8中的一个数，第七列和第八列组合成0-8中的一个数，第九列和第十列组合成0-8中的一个数，第十一列和第十二列组合成0-8中的一个数，第十三列和第十四列组合成0-8中的一个数。

转换规则如下：
33=0   31=1  30=2  13=3  11=4  10=5  03=6  01=7   00=8

转换后的数据变为：
0681077
1540727
.
.
.

谢谢！

cola

=(MATCH(MID(A1,1,2),{"33","31","30","13","11","10","03","01","00"},0)-1)&(MATCH(MID(A1,3,2),{"33","31","30","13","11","10","03","01","00"},0)-1)&(MATCH(MID(A1,5,2),{"33","31","30","13","11","10","03","01","00"},0)-1)&(MATCH(MID(A1,7,2),{"33","31","30","13","11","10","03","01","00"},0)-1)&(MATCH(MID(A1,9,2),{"33","31","30","13","11","10","03","01","00"},0)-1)&(MATCH(MID(A1,11,2),{"33","31","30","13","11","10","03","01","00"},0)-1)&(MATCH(MID(A1,13,2),{"33","31","30","13","11","10","03","01","00"},0)-1)

热线

谢谢 祝cola新年快乐