= if(len(a 1)-len(substitute(a 1，" city "，" "))> 1，MID(A 1，FIND ("city "，A 1)+ 1，FIND ("city "，A 1)+65438。 IF(COUNT(FIND ("county "，A 1)，FIND ("district "，A 1)，FIND ("district "，A 1)+ 1))，mid (a 1，FIND("。 FIND ("county", A 1), FIND ("district", A 1), FIND ("district", A 1)+ 1)-FIND ("city", a 1). FIND ("City "，A 1)+ 1，If (Count ("County "，A 1))，FIND ("County "，A 1)，FIND ("District "，A 1)。 MID(A 1, FIND ("province", A 1)+ 1, FIND ("city", A 1)-FIND ("province", A 1))
Drop-down copy formula
The formula is very long, but the names of provinces including autonomous regions and municipal districts are considered.