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

slg36

e04-slg36
第一题：

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

复制代码

第二题：

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

复制代码

附加题：

1. =MID(SUBSTITUTE(B4,"，","#",3),FIND("#",SUBSTITUTE(B4,"，","#",3),1)+1,3)

复制代码

fuexcel

1. D08：fuexcel
   
2. 第一题：=LEFT(B4,2*LEN(B4)-LENB(B4))
   
3. 第二题：=IF(ISNUMBER(FIND("8",B4)),"Y","")
   
4. 附加题：=MID(B4,FIND("省",B4)-2,3)

复制代码

fuexcel

fuexcel 发表于 2015-6-9 13:07

D08：fuexcel

ytthome

E14:ytthome
1\

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

复制代码

2\

1. =IF(IFERROR(FIND(8,B4),0)>0,"Y","")

复制代码

大猫喵喵

B17：大猫喵喵

第一题

1. 1.=LEFT(B4,4)
   
2.    =LEFT(B5,3)
   
3.    =LEFT(B6,3)
   
4. 2.=IF(ISERROR(SEARCH(B4,8)),"Y",""

复制代码

Anmipoon

c15-Anmipoon
练习答案：
第一题

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

复制代码

第二题

1. =IF(ISNUMBER(MATCH("8",MID(B4,ROW($$$$A$$$$1:$$$$A$$$$100),1),)),"Y","")

复制代码

第三题

1. =MID(B4,FIND("省",B4)-2,3)
   
2.     =MID(B5,FIND("省",B5)-2,3)
   
3.     =MID(B6,FIND("省",B6)-2,3)
   
4.     =MID(B7,FIND("省",B7)-2,3)
   
5.     =MID(B9,FIND("省",B9)-2,3)
   
6.    =MID(B10,FIND("省",B10)-2,3)
   
7.    =MID(B11,FIND("省",B11)-2,3)
   
8.    =MID(B13,FIND("省",B13)-2,3)
   
9.    =MID(B14,FIND("省",B14)-2,3)

复制代码

叶浮溪流

C20：叶浮溪流

1. 不会

复制代码

kjssjshb

1、=LEFT(B4,LEN(B4)-(LENB(B4)-LEN(B4)))
2、=IF(IFERROR((FIND("8",B4)),"")<>"","Y","")
3、=IF(IFERROR((FIND("省",B4)),"")<>"",MID(B4,FIND("省",B4)-2,3),MID(B4,FIND("市",B4)-2,2))

Ruling

A08:Ruling
第一题：

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

复制代码

第一题：

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

复制代码

第二题：

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

复制代码

附加题：

1. =RIGHT(LEFT(B4,FIND(" ",B4)-1),LEN(LEFT(B4,FIND(" ",B4)-1))-FIND("#",SUBSTITUTE(LEFT(B4,FIND(" ",B4)-1),"，","#",3)))

复制代码

zhangxueqin611

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

复制代码

1. =LOOKUP(9^9,--LEFT(B4,ROW($$$$1:$$$$9)))
   

复制代码

1. {=LEFT(B4,COUNT(-LEFT(B4,ROW($$$$1:$$$$9))))}

复制代码

第二题

1. =MID(B4,FIND("座",SUBSTITUTE(B4,"，","座",3))+1,3)

复制代码

附加题

1. =MID(B4,FIND("座",SUBSTITUTE(B4,"，","座",3))+1,3)

复制代码