【函初1班】课前练习二（已开贴）

hello_cgj

想复杂了

1. =LEFT(B4,MATCH(1,-MIDB(B4,ROW($1:$9),1)))

复制代码

1. =TEXT(FIND(8,B4&8),"[<="&LEN(B4)&"]!Y;")

复制代码

1. =MID(SUBSTITUTE(TRIM(MID(B4,MATCH(1,0/N(MID(B4,ROW($1:$99),1)="，"))+1,99))," ",REPT(" ",99)),1,99)

复制代码

郭郭嗯

1. =LEFT(B4,LEN(B4)*2-LENB(B4))
   
2. =IF(ISNUMBER(MATCH("8",MID(B4,ROW($A$1:$A$100),1),)),"y","")
   
3. =SUBSTITUTE(MID(B4,FIND(" ",B4)-3,3),"，","")
   
4. C组：郭郭嗯

复制代码

zuokanyunqi7203

B11：zuokanyunqi7203 不会

dzj4717642

B05：dzj4717642
第一题

1. =LEFT(B4,2*LEN(B4)-LENB(B4))

复制代码

第二题

1. =IF(ISNUMBER(SEARCH("8",B4)),"Y"," ")

复制代码

回答完毕！

chengcheng90

A10:chengcheng90
=LOOKUP(9E+307,--MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&1234567890)),ROW($2:$1025)))

骗子

交作业了

yuhuisjeng

E17：yuhuisjeng
第一题：

1. =LEFT(B4,2*LEN(B4)-LENB(B4))

复制代码

第二题：

1. =IF(TYPE(SEARCH(8,B4))=1,"Y","")

复制代码

附加题：

1. =RIGHT(LEFT(B4,SEARCH(" ",B4)-1),IF(MID(LEFT(B4,SEARCH(" ",B4)-1),LEN(D4)-2,1)="，",2,3))

复制代码

附加题或：

1. =SUBSTITUTE(RIGHT(LEFT(B4,SEARCH(" ",B4)-1),3),"，","")

复制代码

附加题内蒙古自治区版：

1. =MID(SUBSTITUTE(B4,"，","G",3),SEARCH("G",SUBSTITUTE(B4,"，","G",3))+1,SEARCH(" ",SUBSTITUTE(B4,"，","G",3))-SEARCH("G",SUBSTITUTE(B4,"，","G",3))-1)

复制代码

szbaodao

1. 第一题：提取单元格数字,=LEFT(B4,2*LEN(B4)-LENB(B4))
   
2. 第二题：判断含有数字8
   
3. <DIV class=blockcode>
   
4. <BLOCKQUOTE>，=IF(ISNUMBER(FIND(8,B7)),"Y","N")
   

复制代码

附加题：=IF(COUNT(FIND("省",B12)),RIGHT(LEFT(B12,(FIND("省",B12,1))),3),RIGHT(LEFT(B12,(FIND("市",B12,1))),3))
ID:D15：szbaodaoD15：szbaodao
第一题：

1. =LEFT(B4,2*LEN(B4)-LENB(B4))

复制代码

第二题：

1. =IF(ISNUMBER(FIND(8,B7)),"Y","N")

复制代码

附加题：

1. =IF(COUNT(FIND("省",B12)),RIGHT(LEFT(B12,(FIND("省",B12,1))),3),RIGHT(LEFT(B12,(FIND("市",B12,1))),3))
   

复制代码

wqy717642

不好意思不会

antliuliu

1.=LEFT(B4,2*LEN(B4)-LENB(B4))
2，不会
3..buhui