在E列的任意单元格里输入公式如下：=(102203020000+A:A)&"J"
A2：=COUNTIF(D$2:D2,"户主")E2：=IF(D2="户主",10220302&TEXT(A2,"0000J"),"")
