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

baksy

请问返回的小写字母可以吗？

siguoxiang

上交答案 谢谢老师们

siguoxiang

上交答案

冠军欧洲2010

啥也别说了。
先来个长的。

1. =VLOOKUP(MID(A2&"D",MATCH(1,MMULT(N(CHAR(TRANSPOSE(ROW(A$65:A$68)))=MID(A2&"D",ROW($1:$99),1)),ROW($1:$4)^0),0),1),CHAR(ROW(A$65:A$68)),1,)

复制代码

又折腾一个出来。
嘿嘿

1. =MID("ABCD",MATCH(,0/SEARCH(CHAR(ROW($65:$68)),A2&"D"),),1)

复制代码

又省一字符

1. =MID("ABCD",MATCH(,0/SEARCH({"A";"B";"C";"D"},A2&"D"),),1)

复制代码

xiaoni

C2中输入公式：=MID(UPPER(A2&"dabc"),MIN(FIND({"A";"B";"C";"D"},UPPER(A2&"Dabc"))),1)
下拉完成

siguoxiang

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

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

1091126096

66字符

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

复制代码

liziyuliziyu7

凑个   =MID("ABCD",MATCH(,0/SEARCH({"A","B","C","D"},A2&"D"),),1)

xilin5212006

=IFERROR(UPPER(MID(A2,IF(TYPE(SEARCH("A",A2))=16,IF(TYPE(SEARCH("B",A2))=16,IF(TYPE(SEARCH("C",A2))=16,"D",SEARCH("C",A2)),SEARCH("B",A2)),SEARCH("A",A2)),1)),"D")

ddhhyy16

1. =LOOKUP(MID(A2&"D",MIN(SEARCH(CHAR(ROW($65:$68)),A2&"ABCD")),1),CHAR(ROW($65:$68)))

复制代码