A1输入MAC地址。A2输入=LEFT(A1,15)&REPT("0",2-LEN(DEC2HEX(HEX2DEC(RIGHT(A1,2))+1)))&DEC2HEX(HEX2DEC(RIGHT(A1,2))+1),往下拉即可。
大数字累加 ="010210040000851"&ROW(A40496) ;
A1输入MAC地址。A2输入=LEFT(A1,15)&REPT("0",2-LEN(DEC2HEX(HEX2DEC(RIGHT(A1,2))+1)))&DEC2HEX(HEX2DEC(RIGHT(A1,2))+1),往下拉即可。
大数字累加 ="010210040000851"&ROW(A40496) ;
转载于:https://www.cnblogs.com/xihuanjiuquqiqang/p/10139133.html