=IF(mid(A1,1,2)="17","西部",if(mid(A1,1,2)="23","北部","东部" ))
要除开空格:
=IF(A1=0," ",IF(MID(A1,1,2)="17","西部",IF(MID(A1,1,2)="23","北部","东部")))
我试过了,可行.
b1输入
=IF(OR(--LEFT(A1,2)={26,28}),"东部",IF(--LEFT(A1,2)=17,"西部","北部"))
下拉公式填充即可
=INDEX({"西部","北部","东部","东部"},MATCH(LEFT(A1,2),{"17","23","26","28",0}))
然后下拉
可以做个筛选分类,用if函数试试..