TA的每日心情 | 郁闷 2016-10-16 15:53 |
---|
签到天数: 105 天 [LV.6]常住居民II
|
发表于 2008-8-25 15:24:56
|
显示全部楼层
简码
关于简码的问题,可以用公式:=IF(ISNA(LOOKUP(MID(A5,1,1),{"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"垃","L";"嘸","M";"旀","N";"噢","O";"妑","";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"}
)),"",LOOKUP(MID(A5,1,1),{"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"垃","L";"嘸","M";"旀","N";"噢","O";"妑","";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"}
来解决,嘿嘿,自己摸索下吧 |
|