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))