B1输入
=--LEFT(MID(A1,FIND("[",A1)+1,FIND("]",A1)-FIND("[",A1)-1),FIND("d",MID(A1,FIND("[",A1)+1,FIND("]",A1)-FIND("[",A1)-1))-1)
C1输入
=--RIGHT(MID(A1,FIND("[",A1)+1,FIND("]",A1)-FIND("[",A1)-1),LEN(MID(A1,FIND("[",A1)+1,FIND("]",A1)-FIND("[",A1)-1))-FIND("d",MID(A1,FIND("[",A1)+1,FIND("]",A1))))
=--MID(A1,FIND("[",A1)+1,FIND("d",A1)-FIND("[",A1)-1)
=--SUBSTITUTE(MID(A1,FIND("d",A1)+1,5),"]","")
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024