<p>大=SUM((LARGE(--MID(A3,ROW(INDIRECT("1:"&LEN(A3))),1),LEN(A3)-ROW(INDIRECT("1:"&LEN(A3)))+1))*10^(ROW(INDIRECT("1:"&LEN(A3)))-1))</p><p>小=TEXT(SUM((LARGE(--MID(A3,ROW(INDIRECT("1:"&LEN(A3))),1),ROW(INDIRECT("1:"&LEN(A3))))*10^(ROW(INDIRECT("1:"&LEN(A3)))-1))),REPT(0,LEN(A3)))</p><p>定义名称AAA=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE('数组兴趣小组练习题-019期'!$B3,0,),1,),2,),3,),4,),5,),6,),7,)</p><p>=SUBSTITUTE(SUBSTITUTE(AAA,8,),9,)</p> |