[已开][字符争霸第六期]：函数提取首个级别字母

1091126096

64字符。

1. =CHAR(6&MIN(IF(ISERR(FIND({"A","B","C"},UPPER(A2))),8,{5,6,7})))

复制代码

as0810114

60

1. =CHAR(64+IFERROR(MATCH(,0/SEARCH({"a","b","c","d"},A2),),4))

复制代码

tgydslr

1. =MID("ABCD",MIN(IFERROR(FIND(MID(UPPER(A2),ROW(INDIRECT("1:"&LEN(A2))),1),"ABCD"),4)),1)

复制代码

终于有进步了，88字符

tgydslr

1. =IFERROR(CHAR(MIN(IF(ISNUMBER(FIND(CHAR(ROW($65:$68)),UPPER(A2))),ROW($65:$68)))),"D")

复制代码

又减2字符，86个

tgydslr

9楼公优化

1. =MID("ABCD",MIN(IFERROR(FIND(MID(UPPER(A2)&REPT(" ",99),ROW($1:$99),1),"ABCD"),4)),1)

复制代码

85字符

k454058423

PROPER(MID(A2&"D",SMALL(IFERROR(FIND(CHAR(ROW($65:$68)+{0,32}),A2&"D"),99),1),1))
唉...........81字

k454058423

k454058423 发表于 2014-2-18 23:47
PROPER(MID(A2&"D",SMALL(IFERROR(FIND(CHAR(ROW($65:$68)+{0,32}),A2&"D"),99),1),1))
唉...........81字

PROPER(MID(A2&"D",min(IFERROR(FIND(CHAR(ROW($65:$68)+{0,32}),A2&"D"),99)),1))
简：small改min，77字

siguoxiang

siguoxiang 发表于 2014-2-17 15:07
上交答案

=UPPER(IF(MID(A2,MIN(SEARCH({"A","B","C","D"},A2&"ABCD")),1)="","D",MID(A2,MIN(SEARCH({"A","B","C","D"},A2&"ABCD")),1)))

chensir

                         有问题

bc4bc4bc4

100字符
=IF(ISERROR(SEARCH("a",A2)),IF(ISERROR(SEARCH("b",A2)),IF(ISERROR(SEARCH("c",A2)),"D","C"),"B"),"A")
多个等号。。。

94字符
=IF(ISERR(SEARCH("a",A2)),IF(ISERR(SEARCH("b",A2)),IF(ISERR(SEARCH("c",A2)),"D","C"),"B"),"A")
上面2个  验证不过 BA这种循序的~~不过题目上列的都是可以过的

90字符版本1
=UPPER(RIGHT(REPLACE(MID(A2,MIN(IFERROR(SEARCH({"a";"b";"c";"d"},A2),100)),1),1,0,"d"),1))

90字符版本2
=UPPER(RIGHT(MID(REPLACE(A2,1,MIN(IFERROR(SEARCH({"a";"b";"c";"d"},A2),100))-1,"D"),1,2)))