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

一杯清荼

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

复制代码

1091126096

57字符。

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

复制代码

huangcaiguang

=MID("DCBA",MAX(IFERROR(SEARCH(MID(A2,ROW(A:A),1),"DCBA"),)),1)
=CHAR(68-MAX(IFERROR(IF(SEARCH({"A","B","C","D"},A2),{3,2,1,0}),)))
不知道是不是这个意思，，

baksy

=IFERROR(CHAR(MIN(CODE(RIGHT(UPPER(A2),ROW($1:$9)*(ROW()<>9))))),"D")
数组

sgxb123431380

{=MID(UPPER(A2)&"D",MIN(FIND({"A";"B";"C";"D"},UPPER(A2)&"DBCA")),1)}

wlc520113000

1=CHAR(69-MATCH(,-SEARCH({"","c","b","a"},A2)))
2=CHAR(69-MATCH(,SEARCH({"","C","B","A"},A2),-1))
3=CHAR(69-MATCH(,SEARCH({"D","C","B","A"},A2&"D"),-1))
4=CHAR(64+MATCH(,0/SEARCH({"A","B","C","D"},A2&"D"),))
5=IFERROR(CHAR(69-MATCH(,SEARCH({"D","C","B","A"},A2),-1)),"D")
6=IFERROR(CHAR(MATCH(1>0,IFERROR(SEARCHB({"A","B","C","D"},A2)>0,),)+64),"D")
7=CHAR(MIN(IFERROR(SEARCH(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),"abcd"),4))+64)
8=SUBSTITUTE(SUBSTITUTE(UPPER(IFERROR(MIDB(A2,SEARCHB("?",A2),1),"D")),",","D"),"S","C")
9=MID("ABCDABCD",IFERROR(MATCH(1>0,SUBSTITUTE(A2,MID("ABCDabcd",ROW($1:8),1),)<>A2,),4),1)
10=MID("DABC",MOD(MIN(IFERROR(IF(FIND(MID("ABCDabcd",ROW($1:8),1),A2),ROW($1:8)),8)),4)+1,1)
11=IFERROR(MID("ABC",MOD(MATCH(1>0,SUBSTITUTE(A2,MID("ABCDabcd",ROW($1:8),1),)<>A2,),4),1),"D")

蝶·舞

1. =CHAR(MIN(CODE(RIGHT(UPPER(A2&"d"),ROW($1:30)))))

复制代码

tgydslr

1. =MID(UPPER(A2&"d"),MIN(IFERROR(FIND(CHAR(ROW($65:$68)),UPPER(A2&"d")),99)),1)

复制代码

笨笨四

_____________________________________
截止阀
此楼层后不再评分。谢谢支持。