住址分割成多欄 (9140)

B2=LEFT(A2,3)

C2 下拉=LEFT(SUBSTITUTE(A2,B2,),LOOKUP(9,FIND({"鄉","鎮","市","區"},SUBSTITUTE(A2,B2,))))

D2 下拉=TRIM(RIGHT(SUBSTITUTE(A2,C2,REPT(" ",99)),99))