是excel吗 在另外一列，用此公式=IF(LEN(A3)-LEN(SUBSTITUTE(A3,"-",))=3,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A3,"-","号院",1),"-","号楼",1),"-","单元",1)&"室",SUBSTITUTE(SUBSTITUTE(A3,"-","号楼",1),"-","单元",1))&"室"
