在A1或者是B1单元格输入公式：=INT(ROW(A3)/3)&"号楼"&INT(ROW(A3)/3)&"单元"&INT(ROW(A3)/3)&TEXT(ROW(A1),"00")&"室"复制并下拉即可。
