拆分 地址 一公式 (12848)

日期：

B2:D7=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A2,LOOKUP(1,0/FIND({"鄉","鎮","市","區"},$A2),{"鄉","鎮","市","區"}),LOOKUP(1,0/FIND({"鄉","鎮","市","區"},$A2),{"鄉","鎮","市","區"})&" ")," ",REPT(" ",99)),COLUMN(A1)*99-98,99))





留言

張貼留言