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

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

ANGELA
Sorry §Aªº¯uªº¤£ Work¡C
¦³¨Ç Bug¡C

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-4-1 13:32 ½s¿è

¦X¨Ö¤å¦r.zip (12.4 KB)
¨S²Ó¬Ý,¥H¬°ªÅ®æ¬O¤@­Pªº,­ì¨Ó¦³¨º»ò¦hºØ,³o¤½¦¡½T¹ê¤£¾A¥Î­×§ï¦p¤U
©w¸q¦WºÙ: xx=LEN(°ÝÃD!$A2)-LEN(SUBSTITUTE(°ÝÃD!$A2," ",))
  C2 =TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(INDIRECT(LOOKUP(XX,{5,6,7,8},{"B","C","D","E"})&1))*100+1,100))
E2=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(INDIRECT(LOOKUP(XX,{5,6,7,8},{"C","D","E","F"})&1))*100+1,100))
F2=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(INDIRECT(LOOKUP(XX,{5,6,7,8},{"D","E","F","G"})&1))*100+1,100))
G2=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(INDIRECT(LOOKUP(XX,{5,6,7,8},{"E","F","G","H"})&1))*100+1,100))
D2 ¥ÎÅǪ©¥D,Áª©¥Dªº¤èªk¥Î´À¥N§Y¥i.
¤]¥i§ï¦¨
E2=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),(MATCH(XX,{5,6,7,8},)+COLUMN(B1))*100+1,100)) ©¹¥kCOPY ¨ìG2

TOP

Hsieh
ÁÂÁ¡C§Ú¤£¬O«Ü©ú¥Õ¡A¦ý¥i¥H¥Î¡C
!$A1³o­Ó§Ú¤£À´¡A¥[¤W "!"¬O¤°»ò·N«ä¡C§Ú§ä¤£¨ì¬ÛÃö»¡©ú¡C
¦Ó¥B¤@¨B¤@¨B°õ¦æ·|¦³°ÝÃD¡C
¨Ò¦p§Ú§â=LEN(!$A1)©ñ¶i¥hÀx¦s®æ¡A·|±o¨ì¿ù»~°T®§¡C
X ¬O²Ä4­ÓªÅ¥Õªº¦ì¸m¡CChar(10) ¬OLine Feed¡AÀ³¸Ó¥u¬O°µ¬°¤¤Ä~¼È¦sªºÅܼƤ§¥Î¡C

§Aªº¤½¦¡¬O°®²b§Q¸¨¡C¨ä¥Lªº³¡¤À§Ú¥i¥HºCºC¬ã¨s

TOP

¦^´_ 13# Baracuda
¦b©w¸q¦WºÙ¤¤¨Ï¥ÎÅå¼Û¸¹¦ý¥¼¨Ï¥Î¤u§@ªí¦WºÙ
³o¬O¦@¥Î°Ñ·Óªº¼gªk¡A¥u¯à¨Ï¥Î©ó©w¸q¦WºÙ¡A¤£¯à¥Î¨ìÀx¦s®æ¤½¦¡
¦]¬°§Ú¬O¦³¥Î¦hªí´ú¸Õ¡A©Ò¥H¬°¤F­nÅý¨C­Ó¤u§@ªí³£¯à¤Þ¥Î¦¹¦WºÙ¡A©Ò¥H±Ä¥Î³o¼Ë¼gªk
§A¥i¥H§âÅå¹Ä¸¹§R°£¡A¨t²Î¦b©w¸q¦WºÙ¤½¦¡·|¦Û°Ê¥[¤J§@¥Î¤¤¤u§@ªí¦WºÙªº°Ñ·Ó
¾ã­Ó«ä¦ÒÅÞ¿è¦p¤U:
³o¬O¥Î¥h°£ªÅ¥Õ«á¦r¤¸¼Æ¡A»P¥þ³¡¦r¤¸¼Æªº®t¨Ó­pºâ©Ò¦³ªÅ¥Õ¼Æ¶q
±N¦¹¼Æ­È´î¥h3´N¬O­Ë¼Æ²Ä4­ÓªÅ¥Õ¦ì¸m
§â¨º­Ó¦ì¸mªºªÅ¥Õ¥Î¤@­ÓAÄ椣·|¥X²{ªº¦r¤¸¨ú¥N
³o¸Ì§Ú¨Ï¥ÎCHAR(10)³o­Ó´«¦æ¦r¤¸
µM«á§ä¨ì³o­Ó´«¦æ¦r¤¸©Ò¦b¦ì¸m´N¬O¤À¹j¦ì¸m¤F
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Hsieh
ÁÂÁ¡C
³o¼Ë«Ü²M·¡¤F¡C¤½¦¡¨ä¥L¤£ÁA¸Ñªº³¡¤À³£ºâ¤p¨Æ¡C
¡u¦@¥Î°Ñ·Ó¡v³o­Ó¬O§Ú²Ä¤@¦¸¥Î¨ìªº¡C
ÁÂÁ¡C

TOP

Hsieh
ÁÂÁ§Aªº¸Ñµª¡C
§Aªº¤½¦¡³¡¤À¦³¤@¬q¤ñ¸û¡u¼É¤O¡v¡A´N¬OC1=TRIM(MID(A1,x,256))

§Ú¦³°µ¤@¨Ç¤p­×¥¿¦Ó¤w(¤ñ°_§A³oºØ¤j¬[ºc¦Ó¨¥¡A¯uªº¬O«Ü¤pªº­×¥¿)
C1=TRIM(MID(A2,X,LEN(A2)-X+1))
¤£µn¤j¶®¤§°ó¡C

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD