对不起学委 学委辛苦了。
一、=SUM(--MID(A3,ROW(INDIRECT("1:"&LEN(A3))),1))三键结束
=SUM(IFERROR(--MID(A3,ROW($1:50),1),0))三键结束
二、=SUBSTITUTE(MID(SUBSTITUTE(" "&A17," ",REPT(" ",99)),FIND("-",SUBSTITUTE(" "&A17," ",REPT(" ",99)))-30,60)," ",)
三、=LEFT(MID(A30,MATCH(1,--(IFERROR(CODE(MID(A30,ROW($1:99),1)),0)>45217),),99),LENB(MID(A30,MATCH(1,--(IFERROR(CODE(MID(A30,ROW($1:99),1)),0)>45217),),99))-LEN(MID(A30,MATCH(1,--(IFERROR(CODE(MID(A30,ROW($1:99),1)),0)>45217),),99)))三建结束。(我承认这个有点吓死人的长。)
=MID(A30,MATCH(1,N(LENB(MID(A30,ROW($1:$99),1))=2),),LENB(A30)-LEN(A30))三建结束
三、=REPT("●",INT((B44-50)/10))&REPT("○",5-LEN(REPT("●",INT((B44-50)/10))))
=MID("●●●●●○○○○○",6-LEFT(B44-50,1),5)
四、=LEFT(A54,LENB(A54)-LEN(A54))&CHAR(10)&MIDB(A54,SEARCHB("?",A54,1),99)
=REPLACEB(A54,SEARCHB("?",A54,1),,CHAR(10))
|