地址 街路名提取 (12667)

C2{=MID(LEFT(B2,MAX(IFERROR(FIND({"街","路","段"},B2),))),MAX(IFERROR(FIND({"鄰","里","區","市"},B2),))+1,9)



留言