æ¾å¨ä¸ä¸ªåå æ ¼å°±è¡äºï¼è¿éç¨è¿å符为äºæ´å¥½ç让æ°æ®åå¼åæ¢ï¼åå¦B3=1/2Ã3-4+5
é£ä¹C3å ¬å¼å³æå¨ä¸æ=IF(B3="","",IF(--RIGHT(B3,2)=11,"",LEFT(B3,8)&--RIGHT(B3,2)+1))
é£ä¹B4å ¬å¼ä¸æ=IF(B3="","",IF(--RIGHT(B3,2)<11,LEFT(B3,5)&"-"&MID(B3,FIND("-",B3)+1,FIND("+",B3)-FIND("-",B3)-1)+1&"+"&MID(B3,FIND("-",B3)+1,FIND("+",B3)-FIND("-",B3)-1)+2,IF(AND(--LEFT(B3,1)=7,--MID(B3,3,1)=8,--MID(B3,5,1)=9,--MID(B3,7,2)=10,--RIGHT(B3,2)=11),"",IF(AND(--LEFT(B3,1)<7,--MID(B3,3,1)=8,--MID(B3,5,1)=9,--MID(B3,7,2)=10,--RIGHT(B3,2)=11),LEFT(B3,1)+1&"/"&LEFT(B3,1)+2&"Ã"&LEFT(B3,1)+3&"-"&LEFT(B3,1)+4&"+"&LEFT(B3,1)+5,IF(AND(--MID(B3,3,1)<8,--MID(B3,5,1)=9,--MID(B3,7,2)=10,--RIGHT(B3,2)=11),LEFT(B3,1)&"/"&MID(B3,FIND("/",B3)+1,FIND("Ã",B3)-FIND("/",B3)-1)+1&"Ã"&MID(B3,FIND("/",B3)+1,FIND("Ã",B3)-FIND("/",B3)-1)+2&"-"&MID(B3,FIND("/",B3)+1,FIND("Ã",B3)-FIND("/",B3)-1)+3&"+"&MID(B3,FIND("/",B3)+1,FIND("Ã",B3)-FIND("/",B3)-1)+4,IF(AND(--MID(B3,FIND("Ã",B3)+1,FIND("-",B3)-FIND("Ã",B3)-1)<9,--MID(B3,FIND("-",B3)+1,FIND("+",B3)-FIND("-",B3)-1)=10,--RIGHT(B3,2)=11),LEFT(B3,4)&MID(B3,FIND("Ã",B3)+1,FIND("-",B3)-FIND("Ã",B3)-1)+1&"-"&MID(B3,FIND("Ã",B3)+1,FIND("-",B3)-FIND("Ã",B3)-1)+2&"+"&MID(B3,FIND("Ã",B3)+1,FIND("-",B3)-FIND("Ã",B3)-1)+3,))))))