B2输入
=LEFT(A2,4)&"/"&MID(A2,5,2)&"/"&RIGHT(A2,2)
=LEFT(A2,4)&IF(LEN(A2)>4,"."&MID(A2,5,2),"")&IF(LEN(A2)>6,"."&MID(A2,7,2),"")
第二张表,在父科目编码处写公式
=IF(LEN(A5)>4,LEFT(A5,lEN(A5)-3),"")
B2输入
=LEFT(A2,4)&"/"&MID(A2,5,2)&"/"&RIGHT(A2,2)
=LEFT(A2,4)&IF(LEN(A2)>4,"."&MID(A2,5,2),"")&IF(LEN(A2)>6,"."&MID(A2,7,2),"")
第二张表,在父科目编码处写公式
=IF(LEN(A5)>4,LEFT(A5,lEN(A5)-3),"")