A3=TEXT(LEFT(LOOKUP(1,0/(FIND(" ",E$3:E3)>3),E$3:E3)),";;;@")
B3=LEFT(SUBSTITUTE(LOOKUP(1,0/(FIND(" ",E$3:E3)>3),E$3:E3),"*",),3)
C3=SUBSTITUTE(SUBSTITUTE(LOOKUP(1,0/(FIND(" ",E$3:E3)>3),E$3:E3),A3,),B3,)
D3=IF(FIND(" ",E3)>3,"",MID(E3,FIND(" ",E3)+1,99))
留言
張貼留言