急急急!请大神们求救!!Excel里面单元格KE66642001-KE66642100每隔100下拉递增到如KE66642101-KE66642200,KE66642201-KE66642300以此类推,请问如何设置呢?谢谢大神!
C2è¾å ¥
="KE"&66641901+ROW(A1)*100&"-KE"&66642000+ROW(A1)*100
å ¬å¼ä¸æ
C2单元格输入:KE66642001-KE66642100
C3单元格输入:=LEFT(C2,2)&MID(C2,3,8)+100&MID(C2,11,3)&RIGHT(C2,8)+100
向下复制C3单元格