拆分字符串为两列 拆分公式: B: =LEFT(A2,FIND(":",A2)-1) C: =MID(A2,FIND(":",A2)+1,10) find函数是定位字符串; left,mid,right是左选取或右选取