Question

Excel中如何提取两个字符中间的字符串

如1：字符串“科目代码：66.00.100101.00.00.00.00.00.00”，要提取第二个“.”和第三个“.”中间的字符，为“100101”
如2：字符串“科目代码：66.304.4101090201.00.00.00.00.00.00”，要提取第二个“.”和第三个“.”中间的字符，为“4101090201”

Answer 1

=MID(B2,FIND(".",SUBSTITUTE(B2,".",0,1))+1,FIND(".",SUBSTITUTE(SUBSTITUTE(B2,".",0,1),".",0,1))-FIND(".",SUBSTITUTE(B2,".",0,1))-1)

Answer 2

=MID(A2,FIND("@",SUBSTITUTE(A2,".","@",2))+1,FIND("@",SUBSTITUTE(A2,".","@",3))-FIND("@",SUBSTITUTE(A2,".","@",2))-1)