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

上篇: Which of the 36 schemes is Zhuge Liang's calculated story? 下篇: Quantum decoding fortune-telling _ quantum decryption algorithm