![](https://img.51dongshi.com/20250107/wz/18421657652.jpg)
用函數就會...全是數組公式,需按CTRL+SHIFT+ENTER三鍵結束才可以.求冒號個數=SUM(IF(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)=":",1))讀最后一個冒號后面的字符=RIGHT(A1,LEN(A1)-MAX(IF(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)=":",ROW(INDIRECT("1:"&LEN(A1))))))---------------------------------------------終于解決!