Baracuda

gong ÁÂÁÂ
§Ú¥Î±zµ¹ªº¤½¦¡¸ê®Æ¡A§ÚRun ¥X¨Ó¤£workªº³¡¤À¦b©óC,D,E 3­ÓÄæ¦ì¡C
§Aªº¤½¦¡¤ñ¸û½ÆÂø¡A§Ú¼È®ÉÁ٬ݤ£¥X°ÝÃD¬O§Úªº³¡¤À¡AÁÙ¬O¤½¦¡¦³copy »~®t¡C
½Ð§AÀ°¦£ Verify ¦³µLCopy ¿ù¡A§Ú¦A¬ã¨s¤@¤U¡C
FÄ檺°}¦C¤½¦¡¡A«h¬O¥u±o¨ì²Ä¤@Ä檺¤º®e¡C
Fªº¸ê®Æ§Ú·|¦A¬Ý¹L¡AÀ³¸Ó¬O§Úªº°ÝÃD¡C

Baracuda

gong ÁÂÁÂ
§Ú¥Î±zµ¹ªº¤½¦¡¸ê®Æ¡A§ÚRun ¥X¨Ó¤£workªº³¡¤À¦b©óC,D,E 3­ÓÄæ¦ì¡C
FÄ檺°}¦C¤½¦¡¡A«h¬O¥u±o¨ì²Ä¤@Ä檺¤º®e¡C
Fªº¸ê®Æ§Ú·|¦A¬Ý¹L¡AÀ³¸Ó¬O§Úªº°ÝÃD¡C

Baracuda

³o­Ó»¡¨Ó¦³ÂI§¢©V¡C
¦]¬°§Ú¿ù¹L¤Fºô­¶Âà´«®Éªº¤É¯Åªº®É¶¡¡A©Ò¥H§Ú²{¦bªº¨­¤ÀÅܦ¨¤p¾Ç¥Í¡AµLªkDownLoad ¦U¦ìªºÀɮסA¥i§_§â¤½¦¡¯d¤@¦æ¤U¨Óµ¹§Ú¥Î¥Î¡C
­ìª©§Ú¬O¥i¥H Download Àɮתº¡C
ÃÙ§U½×¾ÂÅܦ¨ÃÙ§U·|­û«á¡A¥¿¦n§ïª©¡A©ó¬O§Ñ°O¤É¯Å³o¥ó¨Æ¡C
½Ð¦U¦ì¦P±¡¤@¤U¡A¼È®ÉÀ°À°¦£¡C

Hsieh

§Ú­Ó¤H°¾¦V¨ç¼Æ¥h°µÂ²³æªº
¨ú¥X²Ä¤@­ÓÄæ¦ìÀ³¸Ó³£ª¾¹D¤£Ãø
­n¨ú³Ì«á4Äæ¤@°_¬Û«H¤j®a¤]³£¦³¦n¤èªk
¥u»Ýºâ¥X©Ò¦³ªÅ¥Õ¼Æ¶q´î3¡A¨º­ÓªÅ¥Õªº¦ì¸m¡A´N¬O­n¤Á³Îªº¦ì¸m
¦A§â³o¨â­Ó±o¨ìªºµª®×¨ú¥N¦¨""´N±o¨ì³W®æ
¦A¨Ó¥u­n§â4Äæ¦X¦b¤@°_ªº¸ê®Æ¥Î¸ê®Æ­åªR´N¤j¥\§i¦¨
¦X¨Ö¤å¦r¸ÑÃD.rar (14.12 KB)

¤U¸ü¦¸¼Æ: 12

2011-3-31 16:15

¦bB1¿ï¨úª¬ºA¤U©w¸q¦WºÙ
x=FIND(CHAR(10),SUBSTITUTE(!$A1," ",CHAR(10),LEN(!$A1)-LEN(SUBSTITUTE(!$A1," ",""))-3))
Àx¦s®æ¤½¦¡
B1=TRIM(LEFT($A1,FIND(" ",$A1)))
CÄæ±o¨ì«á¥|Ä檺¤º®e
C1=TRIM(MID(A1,x,256))
DÄæ¨ú±o³W®æ
D1=TRIM(SUBSTITUTE(SUBSTITUTE(A1,C1,""),B1,""))
±NCÄæ½Æ»s/¿ï¾Ü©Ê¶K¤W­È¨ìEÄæ
¹ïEÄæ¥HªÅ®æ¬°¤À¹j²Å¸¹°µ¸ê®Æ­åªR

Baracuda

ANGELA ÁÂÁ¡A§Aªº¤½¦¡ Work ¡C§Ú¦A®ø¤Æ¤@¤U¡C

gong

°Ñ¦Ò
b2=MID($A2,1,FIND(" ",$A2)-1)
{c2=SUBSTITUTE(MID($A2,LARGE(IF(MID($A2,ROW(INDIRECT("1:"&LEN($A2))),1)=" ",ROW(INDIRECT("1:"&LEN($A2)))),4)+1,1000)," "&$E2&" "&$F2&" "&$G2,"")}
d2=SUBSTITUTE(SUBSTITUTE($A2,$B2&" ","")," "&$C2&" "&$E2&" "&$F2&" "&$G2,"")
{e2=--SUBSTITUTE(MID($A2,LARGE(IF(MID($A2,ROW(INDIRECT("1:"&LEN($A2))),1)=" ",ROW(INDIRECT("1:"&LEN($A2)))),3)+1,1000)," "&F2&" "&$G2,"")}
{f2=--MID($A2,LARGE(IF(MID($A2,ROW(INDIRECT("1:"&LEN($A2))),1)=" ",ROW(INDIRECT("1:"&LEN($A2)))),1)+1,1000)}