B2="小径海岸城花园"&LEFT(A2,FIND("-",A2)-1)&"号楼"&TEXT(MID(A2,FIND("-",A2)+1,1),"[dbnum1]")&"单元"&INT(LOOKUP(99^9,-RIGHT(A2,ROW($1:$5)))/100)&"层"&RIGHT(LOOKUP(99^9,-RIGHT(A2,ROW($1:$5))),2)&"号房"
二单元不是大写？
公式：
="小径海岸城花园"&LEFT(A2,FIND("-",A2)-1)&"号楼"&TEXT(LEFT(RIGHT(A2,LEN(A2)-FIND("-",A2)),FIND("-",RIGHT(A2,LEN(A2)-FIND("-",A2)))-1),"[DBNum1][$-804]0")&"单元"&LEFT(RIGHT(A2,4),2)&"层"&RIGHT(A2,2)&"号房"
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024