=MID(DEC2HEX(A2),7,2)&MID(DEC2HEX(A2),5,2)&MID(DEC2HEX(A2),3,2)&MID(DEC2HEX(A2),1,2)
如上图：转换成16进制 倒序排放字符
=CONCATENATE("园区 1期 ",MID(I2,6,1),"幢 ",MID(I2,7,2),"单元")
如上图取字符+中文拼接
