¾e¨ú¤å¦r

tinching

Full Name: Simon Billywong , Sex: Male , Age: 22

½Ð°Ý¦p¦ó¾e¨ú¤W¦C¤å¦r¤¤ªº¡uSimon Billywong ,¡v¡C
ÁÂÁ¡I

Hsieh

¦^´_ 1# tinching


    =MID(A1,FIND(":",A1)+1,FIND(",",A1)-FIND(":",A1))

tinching

¦^´_  tinching


    =MID(A1,FIND(":",A1)+1,FIND(",",A1)-FIND(":",A1))
Hsieh µoªí©ó 2011-2-17 18:47

    ¥i¥H¥Î¤F¡AÁÂÁ¡I

tinching

E-mail: [email protected]

¦A·Q½Ð±Ð¡A¦p¦ó¾e¨ú¤W¦Cºô§}¡AÁÂÁ¡I

Hsieh

¦^´_ 4# tinching


©T©w¦r¦ê¤§«á=SUBSTITUTE(A2,"E-mail: ","")
©T©w²Å¸¹¤§«áªº¦r¦ê=MID(A2,FIND(": ",A2)+LEN(": "),LEN(A2))

tinching

ÁÂÁ Hsieh ª©¥D¸Ñµª¡A¦b»Õ¤U¥¼¸Ñµª«e¡A¤p§Ì¥Î¤F¥H¤Uªº²Â¤èªk¡I

=IF(MID($A$5,2,1)="E",(MID($A$5,10,30)))