China Naming Network - Ziwei Dou Shu - Excel extracts cells to extract city names.
Excel extracts cells to extract city names.
B2 cell writing formula
= if (a2 = "","",substitute (substitute (if ("province", a2), FIND ("city", A2))=2, MID(A2, FIND ("province", A2)+ 1, FIND.
Drop-down filling formula