excel-day11

简单文本函数

 

 

=LEFT(A3,3)

 =MID(A3,4,5)

 

=RIGHT(E3,4)

 

=RIGHT(LEFT(B13,17),1)

 

 

=RIGHT(A2,LENB(A2)-LEN(A2))

 

 

=LEFT(F2,FIND("@",F2)-1)

=MID(F2,FIND("@",F2)+1,100)

 

 

=FIND("-",F10,FIND("-",F10)+1)

 

 

=VLOOKUP(LEFT(B2,6)*1,地区码!A:C,2,0)

=DATE(MID(B2,7,4),MID(B2,11,2),MID(B2,13,2))