=MATCH(SUBSTITUTE(C2,"零","○"),TEXT(ROW($1:$32)-1,"[dbnum1]d"),)-1
(在输入状态按:Ctrl+Shift+Enter,限制于一百以内的数字,像十一到九十九这样的都可以)
=SUMPRODUCT((FIND(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),"○一二三四五六七八九")-1)*10^(LEN(A1)-ROW(INDIRECT("1:"&LEN(A1)))))
这个像一二三这一类的可以用这个公式