当前位置:财税问题 >
實(shí)務(wù)
问题已解决
5號(hào)樓共33層,3單元,每單元3套房,房號(hào)編碼為“樓號(hào)+單元號(hào)+樓層+房號(hào)”,比如5號(hào)樓2單元12層3號(hào)房編號(hào)為 5-2-1203,按單元依次編號(hào)輸入D列,如何快速生成
![](https://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/011/61/32/99_avatar_middle.jpg?t=1714043123)
同學(xué)你好
很高興為你解答
你拍一下表格
我看看能不能用文本連接函數(shù)
2021 10/26 10:18
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84785040 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 10/26 11:53
業(yè)主 房號(hào) 面積
13-1-201
13-1-202
13-1-203
13-1-201
13-1-202
13-1-203
13-1-201
13-1-202
13-1-203
13-1-201
13-1-202
13-1-203
13-1-201
13-1-202
13-1-203
13-1-201
13-1-202
13-1-203
13-1-301
13-1-302
13-1-303
13-1-401
13-1-402
13-1-403
13-1-501
13-1-502
13-1-503
13-1-601
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84785040 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 10/26 11:57
13-1-3101
13-1-3102
13-1-3103
13-1-3201
13-1-3202
13-1-3203
13-1-3301
13-1-3302
13-1-3303
13-2-201
13-2-202
13-2-203
13-2-201
13-2-202
13-2-203
13-2-201
13-2-202
13-2-203
13-2-201
13-2-202
13-2-203
13-2-201
13-2-202 ………………13-3-303 請(qǐng)找快捷錄入方法
![](https://pic1.acc5.cn/011/61/32/99_avatar_middle.jpg?t=1714043123)
鐘存老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 10/26 12:10
你是把一列的數(shù)字變?yōu)槿袖浫氚??
用分列功能
![](/wenda/img/newWd/sysp_btn_eye.png)