来自胡建明的问题
=MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&1234567890)),LEN(A2)*10-SUM(LEN(SUBSTITUTE(A2,{0,1,2,3,4,5,6,7,8,9},))))*1
=MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&1234567890)),LEN(A2)*10-SUM(LEN(SUBSTITUTE(A2,{0,1,2,3,4,5,6,7,8,9},))))*1
1回答
2020-12-05 04:54