WPS表格 编号如何去全部带4的号码怎么操作跳4谢谢？

不难。式子有点长，你试试这个公式：

=HLOOKUP(MOD(INT(ROW(A900)/900),900),{0,1,2,3,4,5,6,7,8,9;0,1,2,3,5,6,7,8,9,0},2,)&HLOOKUP(MOD(INT(ROW(A90)/90),90),{0,1,2,3,4,5,6,7,8,9;0,1,2,3,5,6,7,8,9,0},2,)&HLOOKUP(MOD(INT(ROW(A9)/9),9),{0,1,2,3,4,5,6,7,8,9;0,1,2,3,5,6,7,8,9,0},2,)&HLOOKUP(MOD(ROW(A9),9),{0,1,2,3,4,5,6,7,8,9;0,1,2,3,伯纪应另类它剂厚雨5,6,7,8,9,0},2,)追问 : 详细咋操作的 谢谢 追答 : 你把我这条公式放到表里，然后下拉填充就好啦。追问 : 我的号码段是 60001 和80001的 号段 追答 : 这是60001开头的第一条公式：填好公式后，下拉填充即可。=HLOOKUP(MOD(INT(ROW(A45000)/9000),9000),{0,1,2,3,4,5,6,7,8,9;0,1,2,3,5,6,7,8,9,0},2,)&HLOOKUP(MOD(INT(ROW(A900)/900)-1,900),{0,1,2,3,4,5,6,7,8,9;0,1,2,3,5,6,7,8,9,0},2,)&HLOOKUP(MOD(INT(ROW(A90)/90)-1,90),{0,1,2,3,4,5,6,7,8,9;0,1,2,3,5,6,7,8,9,0},2,)&HLOOKUP(MOD(INT(ROW(A9)/9)-1,9),{0,1,2,3,4,5,6,7,8,9;0,1,2,3,5,6,7,8,9,0},2,)&HLOOKUP(MOD(ROW(A1),9),{0,1,2,3,4,5,6,7,8,9;0,1,2,3,5,6,7,8,9,0},2,)另外80001开头的第一条公式，只需要将上面的公式中，我画红线的数字45000改为63000，即可。