ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¾e¨ú¤å¦r

¾e¨ú¤å¦r

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

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

¦^´_ 1# tinching


    =MID(A1,FIND(":",A1)+1,FIND(",",A1)-FIND(":",A1))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  tinching


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



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

TOP

E-mail: [email protected]

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

TOP

¦^´_ 4# tinching


©T©w¦r¦ê¤§«á=SUBSTITUTE(A2,"E-mail: ","")
©T©w²Å¸¹¤§«áªº¦r¦ê=MID(A2,FIND(": ",A2)+LEN(": "),LEN(A2))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

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

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD