如何判斷儲存格中有冒號 (9496)

A2 下拉=IF(B2="","",N(A1)+1)

D2 下拉=IF(1-ISERR(FIND(":",B2)),"",SUBSTITUTE(LOOKUP(1,0/FIND(":",B$2:B2),B$2:B2),":",))