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

[¤w¸Ñ¨M][µo°Ý]¤½¦¡°ÝÃD-­Ë¼Æ²Än­Ó¯S©w¦r¤¸ªº¦ì¸m

[¤w¸Ñ¨M][µo°Ý]¤½¦¡°ÝÃD-­Ë¼Æ²Än­Ó¯S©w¦r¤¸ªº¦ì¸m

¥»©«³Ì«á¥Ñ Baracuda ©ó 2011-4-1 17:39 ½s¿è

­ì©l¸ê®Æ¦b¡u°ÝÃD¡v¡A­n¨D¥X¡uÀ³¦³¿é¥X¡v
µLªkª½±µ¥Î¸ê®Æ­åªR
¦]¬°¨C­ÓÄæ¦ì¥²©w¦³¡uªÅ¥Õ¡v°µ°Ï¹j¡A¦ý¬O«~¦W³¡¤Àªº¡uªÅ¥Õ¡v¨Ã¤£¬O°Ï¹j

·Q¥X¨Óªº¸ÑÃD¤èªk©Û¤À2¬q
1.¡u®e¶q¡v¡B ¡u³æ»ù ¡v¡B¡u¼Æ¶q¡v¡B ¡uÁ`»ù¡v¬O«á­±ªº4­ÓÄæ¦ì¡A¤©¥H¤ÀÂ÷¥X¨Ó
2.«e¬q¦A¥Î§ä´M²Ä1­Ó¡uªÅ¥Õ¡v¡A¨Ó°µÄæ¦ì¤Á³Î

¦ý¬O¤£·|­Ë¼Æ²Ä4­ÓªÅ¥Õªº¦ì¸mªº¤½¦¡¡A½Ð°Ý¦³¤H¥i¥HÀ°¦£¶Ü¡H

¦X¨Ö¤å¦r¸ÑÃD.rar (8.61 KB)

¥»©«³Ì«á¥Ñ gong ©ó 2011-3-31 01:20 ½s¿è

°Ñ¦Ò
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)}

Book1.rar (8.88 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

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

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-4-1 10:20 ½s¿è

§Ú­Ó¤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)
¦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
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2011-4-1 10:22): §â½׾ÂID¸ò·sID§iª¾¤p»x¡AÀ³¥i«ì´_ÃÙ§U·|­û¨­¥÷
  • ¤p»x(2011-4-1 17:26): ¤§«e§Ú¦³¦Û°Ê¬°±zÂà´«ÃÙ§U·|­û,½Ð¬Ý±zªº­Ó¤H¸ê®Æ,¨ã¦³"½×¾ÂÃÙ§U¾±³¹",¬JµM¦³ºÃ°Ý,²{±N±zªºÃÙ§U·|­û¦³®Ä´Á©µªø¦Ü2011/12/31

³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

TOP

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

TOP

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

TOP

ANGELA §Aªº¤½¦¡§Ú¦³¬Ý¹L¡A§Ú¬ÝÀ´¤F¡C
¦³ÂI¡u¼É¤O¡v¸ÑÃD¡C
¤£¹L Work ¤ñ¸û­«­n¡A³oÃö¥i¥H¥ý¹L¡C
ÁÂÁ§A¡C

TOP

¦^´_ 9# Baracuda


   
¹ïANGELA ªº¤½¦¡§ÚÁÙ¦b§V¤O®ø¤Æ¤¤
¬°¦ó§Ú°µ¥X¨Óµ²ªG¬O¿ùªº?
Ä~Äò§V¤O
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Hsieh
Sorry ¤£¯àµo²°T®§µ¹§A¡C
§Ú­«°µ¡Aµo²{ ANGELA ªº¤½¦¡¦³ Bug
§Ú¤@®É¦³¬Ý¿ù¡C

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD