假设数据在A列，A2开始
B2:=IF(SUM(IF(ISERROR(FIND({1,2,3,4,5,6,7,8,9},A2)),0,1))>0,"级别1","-")
C2:=IF(SUM(IF(ISERROR(FIND({"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"},A2)),0,1))>0,"级别2","-")
B2:C2,下拉到底
条件IF函数...
=IF(ISNUMBER(LOOKUP(,-FIND(ROW($1:$10)-1,A1))),"级别一","级别二")
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024