拆分 棟別與房號 (12849)

B2:C6=TRIM(MID(SUBSTITUTE($A2,"-","棟"&REPT(" ",9)),COLUMN(A1)*9-8,9))

另解=TRIM(MID(SUBSTITUTE($A2,"-",REPT(" ",9)),COLUMN(A1)*9-8,9))&IF($A$1=A$1,"棟","")

分開(棟別) B2=LEFT(A2,FIND("-",A2)-1)&"棟"

分開(房號) C2=MID(A2,FIND("-",A2)+1,9)