EXCEL中怎样让18位的文本型数值自动填充序列答:A1,LEN(A1)-LEN(VALUE(SUBSTITUTE(A1,"53250119","")))&(--RIGHT(A1,LEN(VALUE(SUBSTITUTE(A1,"53250119","")))+1),LEFT(A1,LEN(A1)-LEN(VALUE(SUBSTITUTE(A1,"53250119","")))-1)&(--RIGHT(A1,LEN(VALUE(SUBSTITUTE(A1,"53250119","")))+1)+1))然后向下拉这个公式就好了 ...