=IF(ISERR(FIND("区",A1)),IF(ISERR(FIND("市",A1)),IF(ISERR(FIND("郡",A1)),"",IF(ISERR(FIND("町",A1)),IF(ISERR(FIND("村",A1)),"",LEFT(A1,FIND("村",A1))),LEFT(A1,FIND("町",A1)))),LEFT(A1,FIND("市",A1))),LEFT(A1,FIND("区",A1)))